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