| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced transpose (columns to rows)?
Hello,
I am in need of a way to transpose a portion of a set of data from columns to rows keeping a unique record of the data in column A. Example: FROM: CIRCUIT_PATH_ID PORT_NUM PORT EAGLEVILLE 470 1-1 PORT1 T1-5/0/0:09:01 EAGLEVILLE 470 1-1 PORT2 0961-01 EAGLEVILLE 470 1-1 PORT3 0738-18 EAGLEVILLE 470 1-1 PORT4 01-1 TO: CIRCUIT_PATH_ID PORT1 PORT2 PORT3 PORT4 EAGLEVILLE 470 1-1 T1-5/0/0:09:01 0961-01 0738-18 01-1 Thanks! Jaret |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Advanced transpose (columns to rows)?
Check your other thread.
mcmilja wrote: Hello, I am in need of a way to transpose a portion of a set of data from columns to rows keeping a unique record of the data in column A. Example: FROM: CIRCUIT_PATH_ID PORT_NUM PORT EAGLEVILLE 470 1-1 PORT1 T1-5/0/0:09:01 EAGLEVILLE 470 1-1 PORT2 0961-01 EAGLEVILLE 470 1-1 PORT3 0738-18 EAGLEVILLE 470 1-1 PORT4 01-1 TO: CIRCUIT_PATH_ID PORT1 PORT2 PORT3 PORT4 EAGLEVILLE 470 1-1 T1-5/0/0:09:01 0961-01 0738-18 01-1 Thanks! Jaret -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced transpose (columns to rows) function? | Excel Discussion (Misc queries) | |||
| Transpose data from columns to rows | Excel Discussion (Misc queries) | |||
| How do you transpose rows to columns? | Excel Discussion (Misc queries) | |||
| TRANSPOSE 'group' of columns to rows | Excel Discussion (Misc queries) | |||
| how do I transpose columns and rows | Excel Discussion (Misc queries) | |||
Linear Mode
