| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
flip spreadsheet data from row records to column record fields
I have my spreadsheet with rows as records and columns as fields
I want to change it so that the data is flipped so that the columns are records and the rows are fields. What is the easiest way to do this? |
|
#2
|
|||
|
|||
|
Thank you!
"Peo Sjoblom" wrote: Select the table, copy it, insert a new sheet and do editpaste special and select transpose Regards, Peo Sjoblom "Wasan" wrote: I have my spreadsheet with rows as records and columns as fields I want to change it so that the data is flipped so that the columns are records and the rows are fields. What is the easiest way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
| Find Matching Records in Two Worksheets | Excel Discussion (Misc queries) | |||
| Some exported records do not show on spreadsheet | Excel Worksheet Functions | |||
| How do I flip a column in excel (top becomes bottom)? | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
