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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Another Running Totals Problem 9
Vlookup or similar 7
Excel VBA 1
Two Totals from the same column 2
VLOOKUP forumla for Excel HELP! 1
Scatter plot / Data from matrices? 1
Stuck try to figure out a formula 1
need Macro to combine multiple workbooks into one 5

Back
Top