How do I change columns going from left to right to rows going up.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large worksheet with over 200 columns that I want to change the
orientation so that the column headings are rows. For example: B1 becomes
A2; C1 becomes A3, etc. Can anyone help?
 
You can use a help sheet and just copy the data, select A2 in the new sheet
and do edit>paste special and select transpose

note that if you have more than 256 rows in any of the columns (b1, ci etc)
than it won't work since excel has only 256 columns


Regards,

Peo Sjoblom
 
Steve,

Copy the data, find another place (even if temporary, you can't use the same
place), Paste Special - Transpose.
 
You must log in or register to reply here.

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

Transposing columns to rows 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Merging rows based on column value 2
how to sum up a range of formulas? 5
How to combine multiple columns into different cells in one column 4
Formula from consecutive rows to alternate rows? 2
Adding a cell or column to be included in a sum formula 5
Flip flopping columns and rows 3

Back
Top