Wednesday, February 22, 2012

yogi_Concatenate Grouped Attributes For A Specified Column

Yogi Anand, D.Eng, P.E.                                      Google Spreadsheet                       www.energyefficientbuild.com

user davesmithdub said:
How do I do a kind of pivot and concatenate
Hi
I've prepared a spreadsheet to show what the situation is: https://docs.google.com/spreadsheet/ccc?key=0AiRLtUqKvuCbdFYtU2I4M3ZEelBXM0RxQTJGS0VKOEE
.. 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
Dave
------------------------------------------
following is a solution to the problem