Conditional Copying - Variable Ranges - Sprint Cell Phone Usage Import

I am working on a project to import cellular phone usage data from Sprint into a workbook.

All cells in Column A are blank. Column B contains 1 instance of the cell phone account #, followed by dates of calls made, which continues until the next cell phone account # appears, and it’s calls made. The # of calls made obviously varies per account #.

The dates are in date format. The cell phone account # is in text format and is formatted with blue fill.

I need to copy the cell phone account # into column A for each line that has a date value in ColumnB, but the value copied must change when it reaches the next cell phone account #, so that the calls are matched up with the cell phone account # and can be imported into SQL.

Acct #
Date
Time
City Called from
State Called From
Called #
City Called
State Called................