Home |
Search |
Today's Posts |
#1
|
|||
|
|||
flip spreadsheet data from row records to column record fields
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 | |||
create excel spreadsheet to display data from filled text forms | Excel Discussion (Misc queries) | |||
Find Matching Records in Two Worksheets | Excel Discussion (Misc queries) | |||
Formula to post data in another spreadsheet | Excel Worksheet Functions | |||
Flip the X and Y data on a chart so that the Y data is vertical. | Charts and Charting in Excel | |||
Creating a summary from existing spreadsheet data ... | Excel Worksheet Functions |