| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I invert data so that the columns become rows??
I have a block of data where I would like the columns to be rows and the rows
to be columns. Is there a simple way to flip the data? |
|
#2
|
|||
|
|||
|
Use Copy followed by Edit|Paste Special-Transpose
Make a second copy of you file before doing this - just in case you mess up best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "jsloman" wrote in message ... I have a block of data where I would like the columns to be rows and the rows to be columns. Is there a simple way to flip the data? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| can i restrict data entry from certain columns | Excel Discussion (Misc queries) | |||
| Text to Columns / Importing Data | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Linear Mode
