column 2 to transpose using column 1 as reference

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike F - 31 Aug 2007 20:48 GMT

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 to this Message

roadkill - 31 Aug 2007 22:28 GMT

I don't see the pattern/rule in your transposition. I trust you already
tried copy followed by paste special/transpose?
Will

> Hello... please help with solution.
>
[quoted text clipped - 5 lines]
> 1004 1005
> 1004 1006

Reply to this Message

Mike Fong - 31 Aug 2007 22:34 GMT

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...

> I don't see the pattern/rule in your transposition. I trust you already
> tried copy followed by paste special/transpose?
[quoted text clipped - 9 lines]
> > 1004 1005
> > 1004 1006

Reply to this Message