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
|