Monday, 11 December 2017
  1 Replies
  3.9K 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.