Unpivot columns that start with letter m

[Anonymous]

Hi, 

Hope somebody can help me. I tried to search in google and that forum, but I couldn´t find and answer or solve my problem.  I have  multiple columns that sarted with letter "m*", and the database that I retrieve, could change along time. So, I need to unpivot the columns that started with letter m instead of doing manually. 

Hope you  Understand my explanation.

Thanks.

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous 

I created a small example.

Please see attached File's Query Editor

First we determine the columns to pivot

Then we can use this list in Table.Unpivot function

 ColumnsToPivot = List.Select(Table.ColumnNames(#"Changed Type"),each Text.StartsWith(_,"m")),
    #"Unpivoted Columns" = Table.Unpivot(#"Changed Type", ColumnsToPivot, "Attribute", "Value")

[Anonymous]

Thanks a lot for the quickly answer and for the solution!! 

Thanks for the attachment too. I´m saving it like a treasure!