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

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 column
containing "record 1:" etc. In the first "Sort By" box. then click
ok. Then highlight only the cells containing "a1, b1" etc... repeat
steps 2) and 3) then click "Options" Select "Sort left to right." and
then "ok". click "ok in the sort window and your data should be
arranged in the way you want it.

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

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


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=484663

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

Dan wrote:
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