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:-

RoomRedYellowGreen
AYesNoYes
BYesYesYes

 

1st Output as:-

RoomYes
ARed, Green
BRed, Yellow & Green


2nd Output as:-

RoomColorYes/No
AYellowNo
BGreenYes


Please let me know if you need any details from my side.

Thanks & Regards,
S

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?

1 Reply

  • 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?