| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transposing
COL A has 165,000 cells that looks like this:
CONTROL-NBR 1 DATA1 DATA2 DATA3 CONTROL-NBR 2 DATA1 DATA2 DATA3 DATA4 DATA5 DATA6 CONTROL-NBR 3 DATA1 CONTROL-NBR 4 DATA1 DATA2 DATA3 DATA4 DATA5 How can I transpose the "DATA" cells for each "CONTROL-NBR" onto the same row as the "CONTROL-NBR" so the result looks like this:: CONTROL-NBR-1 DATA1 DATA2 DATA3 CONTROL-NBR-2 DATA1 DATA2 DATA3 DATA4 DATA5 DATA6 CONTROL-NBR-3 DATA1 CONTROL-NBR-4 DATA1 DATA2 DATA3 DATA4 DATA5 (Note: The number of "DATA" cells for each "CONTROL-NBR" varies from 1 to 30). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need help with transposing | Excel Discussion (Misc queries) | |||
| Transposing | Excel Discussion (Misc queries) | |||
| Transposing | Excel Worksheet Functions | |||
| TRANSPOSING | Excel Programming | |||
| TRANSPOSING | Excel Discussion (Misc queries) | |||
Threaded Mode
