Forum Discussion

msciarrino's avatar
msciarrino
Helper I
2 years ago
Solved

Combine 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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.