transform data in excel

V

Vincent Yang

I need to transform data in an excel srpeadsheet. I need to reverse a
5 rows, 200 columns table into a 5 columns, 200 rows table.

Much appreciated!Vincent
 
R

Roger Govier

Hi Vincent

Copy the set of data.
Got to your destination and choose Paste Special and click the box marked
Transpose.
 

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

Cell data entering slow! 0
Add additional information to excel form after original data entry 0
Vlookup or similar 7
Consolidation Table from Different Excel Tabs with Different Format 1
Excel --> Word 4
Merge Excel file into Word Document 3
xml transforms to rearrange worksheet data? 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0

Top