Hi Sarah,
I assume you want the 13 titles in the first record to be column
headings across the top with the appropriate data under each title.
To do that, you select the range A1 to B13 and copy it. Select the cell
where you want the reorganized data to display and right-click, choose
Paste All, Operatin None and check Transpose. Then click OK.
How is that for a start?
ExcelGirl
--
ExcelGirl
------------------------------------------------------------------------
ExcelGirl's Profile:
http://www.excelforum.com/member.php...o&userid=25272
View this thread:
http://www.excelforum.com/showthread...hreadid=387655