Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Monday, 11 December 2017
  1 Replies
  3.5K 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.