Hello. I've got a spreadsheet containing a Key column which has a unique key for a variable number of rows that belong to a group. I need to aggregate the values of a particular column into the first row that has that key. For example, I need to turn this:
Key Date Num Status Another Date Color
#GU925693 11/1/2017 0:08 fulfilled 11/15/2017 16:09 Blue
#GU925693 11/1/2017 0:08 Lime
#GU925693 11/1/2017 0:08 Purple
#GU925694 11/1/2017 0:09 fulfilled 11/15/2017 13:26 Blue
#GU925695 11/1/2017 0:26 fulfilled 11/15/2017 16:09 Black
#GU925695 11/1/2017 0:26 Blue
Into this:
#GU925693 11/1/2017 0:08 fulfilled 11/15/2017 16:09 Blue Lime Purple
#GU925694 11/1/2017 0:09 fulfilled 11/15/2017 13:26 Blue
#GU925695 11/1/2017 0:26 fulfilled 11/15/2017 16:09 Black Blue
I was hoping that KU's Combine might get me there, but it doesn't support selection by keys.
Any help pointing me in the right directly would be very appreciated!
Thanks,
Steve