| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
column 2 to transpose using column 1 as reference
Hello... please help with solution.
col1 col2 col1 col2 col3 col4 1001 1001 to 1001 1001 1002 1003 1001 1002 1004 1004 1005 1006 1001 1003 1004 1004 1004 1005 1004 1006 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
column 2 to transpose using column 1 as reference
I don't see the pattern/rule in your transposition. I trust you already
tried copy followed by paste special/transpose? Will "Mike F" wrote: Hello... please help with solution. col1 col2 col1 col2 col3 col4 1001 1001 to 1001 1001 1002 1003 1001 1002 1004 1004 1005 1006 1001 1003 1004 1004 1004 1005 1004 1006 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
column 2 to transpose using column 1 as reference
Thanks roadkill for the reply,
I have a list 1800 records long. Col1 has repeat data. Col2 has unique data. Copy and paste will take me quite a long time. I am trying to find a better way. Thanks in advance... "roadkill" wrote: I don't see the pattern/rule in your transposition. I trust you already tried copy followed by paste special/transpose? Will "Mike F" wrote: Hello... please help with solution. col1 col2 col1 col2 col3 col4 1001 1001 to 1001 1001 1002 1003 1001 1002 1004 1004 1005 1006 1001 1003 1004 1004 1004 1005 1004 1006 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| transpose links from a column to a row | Excel Worksheet Functions | |||
| how do I transpose a column of 80 numbers into... | Excel Discussion (Misc queries) | |||
| transpose links from a column to a row | Excel Worksheet Functions | |||
| transpose column to a row? | Excel Discussion (Misc queries) | |||
| transpose a column into many rows | Excel Discussion (Misc queries) | |||
![Mike F[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
