View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AL
 
Posts: n/a
Default How can I do a one to many merge in Excel?

Hi, I am trying to merge two sets of data into one using a one to many merge,
for example:
In column A, I have In column B, I have
100 101
200 102
300 103

my results column will look like:
100101
100102
100103
200101
200102
200103
300101
300102
300103

Any help would be appreciated.

AL