Forum Discussion

Sumeesh's avatar
Sumeesh
Regular Visitor
3 years ago
Solved

Return multiple Column Header based on excel value in rows

Hi Team, Need your help in getting output as stated below:- Input table data:- Room Red Yellow Green A Yes No Yes B Yes Yes Yes   1st Output as:- Room Yes A ...
Need Help
  • baghdadi62's avatar
    baghdadi62
    3 years ago

    Hi,

    First, unpivot the color columns.
    Then, filter the 'Value' column for the 'Yes' value.
    Next, use the Group By operation and modify its formula as follows:
    Text.Combine([Attribute],", ")

     

     

    and let me know the logic behind the 2nd output?

baghdadi62's avatar
baghdadi62
Resolver III
3 years ago

Hi,

First, unpivot the color columns.
Then, filter the 'Value' column for the 'Yes' value.
Next, use the Group By operation and modify its formula as follows:
Text.Combine([Attribute],", ")

 

 

and let me know the logic behind the 2nd output?