turn columns into rows

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

Guest

I have a large spreadsheet that I'd like to have in two separate formats:
One, with Data X in Columns and Data Y in Rows, the other with Data Y in
Columns and Data X in Rows. How can I do this while preserving the data?
 
Select data, right click, choose "Copy".

Right click in first cell of new location, choose "Paste Special", and click
on "Transpose", then <OK>.

Don't forget ... you only have 256 columns.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a large spreadsheet that I'd like to have in two separate formats:
One, with Data X in Columns and Data Y in Rows, the other with Data Y in
Columns and Data X in Rows. How can I do this while preserving the data?
 
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

Using COUNTU in VBA to delete certain values 2
How to separate x y data in 1 column to 2 colums of x and y data? 6
Excel - changing column reference based on value of other column 4
Appending Data from one spreadsheet to another 4
variable sheet name 6
Excel Help to copy information from one row at a time to another sheet 1
X-Y gridded data into columns 2
Dynamic chart ranges 1

Back
Top