How can I do a one to many merge in Excel?
Hi Ron,
I tried it, but it didn't work. I got an error message that says "This data
source contains no visible tables" right after I did the browse to the file
step.
AL
"AL" wrote:
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
|