I've got a rather long spreadsheet with 2 columns. There are about 200,000 rows overall and about 40,000 unique values in column A. Column B only has about 3000 values.
I need to create a list of the unique values in column A with the values from Column B being concatenated so that the result is a list of the about 40,000 unique values in Column A with Column B being anywhere from 1-10 values (combined with some delimiter).
This can be a list with these 2 columns on the same sheet, a different sheet, whatever...
Is there a way to do this with pivot tables or some plug-in (free or low cost)? Both my columns are Text.
An example of something like this would be a list of last names (Column A) and first names (Column B) with me wanting to show all the first names (combined from Column B) separated by commas for every unique Last name (Column A). That's not a perfect example, but roughly what I need to do.
This is Excel 2016 on Windows 10.