How do I copy data from one cell to the next occurrence of data?

[excelmad]

I have a very large file in which I need to copy the SSN down to the point
where the next SSN begins. How can I accomplish this task?

I have information in a worksheet as follows:

SocialSec # Acct Bal Type Amount
Row1 SSN Account BalA 50.00
Row2 Account BalC 100.00
Row3 Account BalD 250.00
Row4 SSN #2 Account BalA 50.00
Row5 Account BalC 14.00
Row6 Account BalD 75.50
Row7 Account BalE 35.00
Row8 SSN #3 Account BalA 22.00
Row9 Account BalB 25.00

 

[Duke Carey]

Insert a temporary column to the left of your SSNs
Assuming your SSns are in col B (after the insert) and start in row 2, use
this formula in A2, and copy it down.

Do this on a copy of your data

=IF(ISBLANK(B2),A1,B2)

After copying it down all the way, select all the formulas, copy them,
select the cells with the original SSNs, and use Edit->Paste Special->Values

 

[Kevin Vaughn]

I like this method which I copied from a post here, but have also seen in a
John Walkenbach book:

Select column A. Hit F5. Click on Special. Click on Blanks, then OK.
Type = and then hit Up Arrow. Hold Control Key and hit Enter.

 

[excelmad]

Thank you so much...it worked perfectly.

Insert a temporary column to the left of your SSNs
Assuming your SSns are in col B (after the insert) and start in row 2, use
this formula in A2, and copy it down.

Do this on a copy of your data

=IF(ISBLANK(B2),A1,B2)

After copying it down all the way, select all the formulas, copy them,
select the cells with the original SSNs, and use Edit->Paste Special->Values

 

[excelmad]

This works awesome too. Thank you.

I like this method which I copied from a post here, but have also seen in a
John Walkenbach book:

Select column A. Hit F5. Click on Special. Click on Blanks, then OK.
Type = and then hit Up Arrow. Hold Control Key and hit Enter.

 

[Kevin Vaughn]

You're welcome.
--
Kevin Vaughn

This works awesome too. Thank you.