Change Column heading to row

  • Thread starter Thread starter learning_codes
  • Start date Start date
L

learning_codes

Hi,

I'm new. I have huge column 200 columns that have heading. I want
200 headings to move 200 rows on the excel spreadsheet.

Your help would be much appreciated.

Thanks
 
Copy the 200 column headings and paste/special check transpose to the column
where you want the column headers to be row headers. Save your workbook
first.

Tyro
 
Check out help on "Transpose"

Note: if using any version earlier than 2007 you will be able to transpose only
256 rows to columns.


Gord Dibben MS Excel MVP
 
Back
Top