switching columns to rows

[melamaric]

I have 10 columns with headers with a row of information beneath each header, but I want to switch them around so that the column headers become the first items in each row, i.e., 10 rows down and the row of information becomes the information in column B.

Thanks for the assistance! :wink:

 

[fairwinds]

Hi,

Try:

Copy - paste special - transpose

 

[babycody]

Try this link on the transpose function: http://www.tomkeays.com/blog/archives/2004/12/06/000630.php

Is this what you are looking for?

 

[melamaric]

Thank you--worked like a charm!!