Change data to appear in rows instead of columns (reverse a table.

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

Guest

I have a fairly large table in which I need to switch the columns to the
rows. Is this possible to do?
 
I would use a help sheet, select the table, copy it, select the first cell
where you want it on the help sheet,
do edit>paste special and select transpose. Obvisouly if you do it the other
way you have to
bear in mind that you can only transpose 256 rows due to the max number of
columns
 
hi,
excel will pastespecial>transpose a single column but i am
not aware of an easy way to do a whole table.
you said large table. if you are transposing columns to
rows then you are also tranposing rows to columns and if
you have more that 256 rows to transpose, then you wont be
able to do this because that is all the columns that excel
has.
 
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

VBA - retrieve data on last create named range from previous inserted named range 0
How to invert Cols/Rows? 2
Conditional SUBTOTAL in XL210 Table 7
Excel Help to copy information from one row at a time to another sheet 1
Would Like Pivot Table Data on 1 Row instead of Stacked Column 1
Sorting Column A & Include date in the Entire Row 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Getting Text data using the Data - Subtotal feature 1

Back
Top