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