Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic unpivot of columns in Power Query

Hi, I am using the function = Table.Unpivot(#"Filtered Rows1", {"x","y","z"...}, "Attribute", "Value") to unpivot a table by those selected rows.   However, they are input values and will change a...
General Comment
Need Help
Tips and Tricks
  • ronrsnfld's avatar
    ronrsnfld
    4 years ago

    Something like:

    = Table.Unpivot(#"Filtered Rows1", List.RemoveFirstN(Table.ColumnNames(#"Filtered Rows1"),3), "Attribute", "Value")
ronrsnfld's avatar
ronrsnfld
Super User
4 years ago

Something like:

= Table.Unpivot(#"Filtered Rows1", List.RemoveFirstN(Table.ColumnNames(#"Filtered Rows1"),3), "Attribute", "Value")
mathur786's avatar
mathur786
New Member
2 years ago