Record data on two lines

[Dan]

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

 

[goober]

A simple way is to 1) select all of the data fields. 2) Click on "Data
on the top tool bar. 3) then select "Sort". Choose the colum
containing "record 1:" etc. In the first "Sort By" box. then clic
ok. Then highlight only the cells containing "a1, b1" etc... repea
steps 2) and 3) then click "Options" Select "Sort left to right." an
then "ok". click "ok in the sort window and your data should b
arranged in the way you want it.

you then should probablygo back into the "options" window and chang
the selection back to "Top to bottom" click "ok" then click "Cancel".

Hopefully I'm clear and not to wordy. Hope it helps

 

[Dan]

Thanks, Goober...
I'll try it tomorrow at the office.
Dan