A table can be divided into Groups of rows by the value of a key field.
Normally, one can collapse the values of a field in each Group into a single statistic, such as Total or count.
But I need to collapse the Groups of a field in a table into a list. That is, to collect the values of a text field belonging to a Group, and concatenate them into a single text.
Let me explain.
I have a table that, say, looks like this:
Group Word
1 bee
2 cee
2 dee
2 deed
3 cede
3 ace
3 dace
3 bade
4 babe
I would like to create a new table that looks like this:
Group WordList
1 bee
2 cee, dee, deed
3 cede, ace, dace, bade
4 babe
Perhaps just a subquery in a Select statement would do it?
I have looked at doing this in Excel, Access, VBA, and, finally, Power Query.
To no avail.
A solution in Power Query (my new toy) is fine, but any other tool is OK also.
I would hate to resort to manual labor, as I have a total of 6600 words grouped in about 640 Groups. And I may have to do this a couple of times, as the structure might change in the future.
Help me, oh, please help me.