View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike F[_2_] Mike F[_2_] is offline
external usenet poster
 
Posts: 1
Default 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