How do I compile data in different rows and output to a new column

J

Jose G Morales

for the sake of simplicity, This Table has a column for names and a column
for seating assigments,
Joe, table1
Mary, table1
Peter, table2
Frank, table2
I want to output as follows:
table1, Joe and Mary
table2, Peter and Frank
I know it could be done, please shed some light on my old brain
thanks.
 
J

Jose G Morales

That was very helpful and I was able to adapt it to my table.
thank you very much
 
M

Marshall Barton

You're welcome, but Duane, deserves all the credit for
creating the function and making it available to the rest of
us.
 
Top