Combine particular columns into a single cell, based on key column

Question

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

根据关键列将特定列合并到单个单元格中