| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transposing based on cell value
Hi,
I have 30,000 rows of data (exported from a text file) in the following manner: Date: xxx Name:xxx Shift:xxx Category A line 1 line 2 line 3 etc... Category B line 1 line 2 line 3 etc.. and I want to convert the data into columns: Date Name Shift Category A Category B line 1 line 2 line 3 Any suggestions on how to do that? Thanks in advance Karim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transposing contents of a cell | Excel Discussion (Misc queries) | |||
| Transposing Multiple Cell References to Multiple Values (NOT total | Excel Discussion (Misc queries) | |||
| Transposing Multiple Cell references as Multiple Values | Excel Discussion (Misc queries) | |||
| Transposing | Excel Worksheet Functions | |||
| Deleting Rows based on text in cell & formatting cell based on text in column beside it | Excel Programming | |||
Threaded Mode
