Sorry about repeating the post but I think I messed up the first one
yeaterday!

I am receiving a spreadsheet from an agency with record information on
two lines.
Example:
Record 1: A1, B1, C1, D1, A2, B2, C2
Line 3 blank
Record 2: A4, B4, C4, D4, A5, B5, C5

There are over 100 records like this. They claim they can't fix it...
It originates from a Crystal Report.

How can I change the data so each record is on one line:

Record 1: A1, B1, C1, D1, E1, F1, G1
Record 2: A2, B2, .......................G2

Thanks for any help!
Dan