PowerQuery how to merge 3 column into 1

[GerryZ]

Hello Excel friends
I'm stuck with this solution propably easy but I don't know how
see this image below

Thank you

 

[sandy666]

Thank You I did it

You are welcome, I am glad it works for you
Thanks for the feedback

 

[sandy666]

You can do this with GUI only

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Transpose = Table.Transpose(Source),
// --select all columns and use Unpivot Columns----
    UC = Table.UnpivotOtherColumns(Transpose, {}, "Attribute", "Value"),
    RC = Table.RemoveColumns(UC,{"Attribute"})
in
    RC