| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I rotate data in a spreadsheet so that rows become columns?
Once again I find myself needing to do something in Excel that I know SHOULD
be possible, but have never figured out HOW. I've captured meaningful data as text and pasted it in Excel. First row is "name", second row is "address", third row is "city", fourth row is blank and then the fifth row starts with the next record's "name". My need and desire is to rotate this data so that column one is "name", column two is "address", column three is "city" and each row is a separate record. Assistance please! Thanks!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extracting data from a spreadsheet by searching on columns | New Users to Excel | |||
| Need help with Converting Rows of data into 2 columns | Excel Worksheet Functions | |||
| Data in table, may need to convert to columns with OFFSET? | Excel Discussion (Misc queries) | |||
| Data from a number of rows and columns to one column | Excel Discussion (Misc queries) | |||
| Data Filter - Not all rows in spreadsheet will display in Autofilt | Excel Worksheet Functions | |||
Threaded Mode
