Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Monday, 11 December 2017
  1 Replies
  3.7K Visits
0
Votes
Undo
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
6 years ago
·
#1348
0
Votes
Undo
Hello,
Thanks for contacting us.
Sorry, we don't have such function yet.
We will consider to add it in the future.
  • Page :
  • 1
There are no replies made for this post yet.