Wednesday, February 22, 2012

yogi_Concatenate Grouped Attributes For A Specified Column

Yogi Anand, D.Eng, P.E.                                      Google Spreadsheet             

user davesmithdub said:
How do I do a kind of pivot and concatenate
I've prepared a spreadsheet to show what the situation is:
.. and here's an explanation: The above link has a Source Array with two columns: Names and Dates.
What I want is to have an output where there are two columns: Dates, which contains unique dates and Names, which contains concatenated names (because there can be more than one name per date)
I looked into doing this with something like =Query(A:B, "select B pivot A") but I'm hitting a wall with a missing aggregation function.
all the best
following is a solution to the problem