Power Query - Return column name each time specific cell value is detected?

Question

Hey guys!
I got this Table in the Power Query Editor. There are several Persons with different Attributes.

How can I get my table in a format like this in the Power Query Editor? The first row schould be the person and the second is filled with the attributes were the value is one. They should be in a single row with a seperating figure.

If you could help me that would be awesome and would safe my day!

Answer 1

Hi

    PreviousStepName = ...
    UnpivotedOtherColumns = Table.UnpivotOtherColumns(PreviousStepName, {"Person"}, "Attribute", "Value"),
    FilteredValues = Table.SelectRows(UnpivotedOtherColumns, each ([Value] = 1)),
    GroupedRows = Table.Group(FilteredValues, {"Person"},
        {{"Attributes", each Text.Combine([Attribute],", "), type text}}
    )