Forum Discussion
Helper ICombine Text based on condition from different column
Hello,
I am trying to combine text based on the value in a different column. I would prefer to do this in power query but open to all answers.
Sample Data
The last column is what I am trying to achieve.
I am trying to combine the text in the Name column based on the value from the Group column.
Thank you for your help.
Hi msciarrino
For your question, here is the method I provided:
Here's some dummy data
Select "Transform data" to enter the power query
Select “Group”, and select “Group By” in the “Transform”
Select “Sum” and “Name”
Modify the code
Here is the result, and select “Close & Apply”
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi msciarrino
For your question, here is the method I provided:
Here's some dummy data
Select "Transform data" to enter the power query
Select “Group”, and select “Group By” in the “Transform”
Select “Sum” and “Name”
Modify the code
Here is the result, and select “Close & Apply”
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.