I've thought about array's and recordsets, but was wondering if there is an easier way.
I have table like this:
Name Address
Bob 123 Main Street
Jane 89654 Elm Street
Bob 3547 Island Circle St.
Jane 900 River Drive
I would like to turn the above data into this:
Name Final
Bob 123 Main Street, 3547 Island Circle St.
Jane 89654 Elm Street, 900 River Drive
Thanks for all your help.
I have table like this:
Name Address
Bob 123 Main Street
Jane 89654 Elm Street
Bob 3547 Island Circle St.
Jane 900 River Drive
I would like to turn the above data into this:
Name Final
Bob 123 Main Street, 3547 Island Circle St.
Jane 89654 Elm Street, 900 River Drive
Thanks for all your help.