How do you rotate a table of excel data from horizontal to vertic.

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

Guest

I just want to take a table of 2 rows by 100 columns and turn it into a 2
column table. How can I do this?
 
hi,
copy a row. Select a cell where you want to put the column.
edit>paste special>transpose.(towards the bottom of the
paste special form)
the row in now a column.
do that with the other row.
 
Select the whole set of cells (say it's A1:CV2), Edit/Copy it, then select A3,
Edit/Paste Special and select the Transpose option. Now you can delete rows
1:2.
 
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

Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
In Excel can I rotate a column from vertical to horizontal. 3
How to Convert same horizontal row to vertical row in Excel? 3
How to export table from outlook into ms access table? 0
VBA - retrieve data on last create named range from previous inserted named range 0
copying/pasting accurately from a Word table (carriage returns) 1
Lookup help 5
How to rotate graph 90 degrees 1

Back
Top