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
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
