Group and sum delimited values

NurlanPQ

New member
Joined
Nov 28, 2018
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2019
Greetings to all!

I urgently need to convert this table:
intermediate table.png

into this:
prefinal table.png

the problem is as follows:

  • Find a unique combination of Data1, Data2, Data3 by row
  • Group by each combination found so that I get lists in the Elements column and sums in the Value columns.
  • I'm just starting to learn PQ :)
  • Please help!


Regards,
Nurlan
 

Attachments

  • Initial data 2.xlsx
    10.4 KB · Views: 17
Hi Nurlan,
I see that your post is old and hope that you were able to solve your problem. If not and you still need it, here is the PQ piece.
Regards,
Mike
 

Attachments

  • Initial data 2.xlsx
    20.1 KB · Views: 21
Back
Top