| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
converting data in colums to rows
I have a sheet that has been setup that shows a list of documents in one
cloumn and 4 rows are dedicated to indicating reference documents. ie drawing 1, desc 1, desc2, ref1, ref2, ref3, ref4 where ',' represents a different column. I want to convert this to the following format drawing 1, desc 1, desc 2, ref1 drawing 1, desc 1, desc 2, ref2 drawing 1, desc 1, desc 2, ref3 drawing 1, desc 1, desc 2, ref4 Any ideas?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| how to split data from 1 row into two rows continuously | Excel Worksheet Functions | |||
| Unhiding rows using data validation | Excel Worksheet Functions | |||
| inserting rows through external data source | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
