Need help to combine all the rows from several colums into one new colum

[DBricklin1979]

Hi,

I need help to combine all the rows from several colums into one new colum in Power Query. Is there a simple way. If I were to use Excel I would just copy and past but I am trying to see if I can save some time using Power Query instead. Please see example below.

Thanks in advance for any help given! 

[unhinged]

//First one
let
    Source = Excel.CurrentWorkbook(){0}[Content],
    Index = Table.AddIndexColumn(Source, "Index", 0, 1, Int64.Type),
    Unpivot = Table.SelectColumns(Table.UnpivotOtherColumns(Index, {"Index"}, "Kolumn", "Value"), {"Value"})
in
    Unpivot

//Second one
let
    Source = Excel.CurrentWorkbook(){0}[Content],
    ColNames = Table.ColumnNames(Source),
    acc = List.Accumulate(ColNames,
                 {},
                 (state,current)=> List.Combine({
                                            state,          
                                            List.Transform(Table.Column(Source, current), (value) => Text.From(value))
                                                })
    ),
    tbl = Table.FromList(acc)
in
    tbl

[DBricklin1979]

Thanks @unhinged ! I am sure your solution works but I did already manage with the previously presented solution from devehus. Thanks anyway!

[davehus]

Hi @DBricklin1979 ,

Have you go PowerBI installed on your machine? You can used the code generated through powerquery in excel.

[DBricklin1979]

I have not been using PowerBi before but now I tried and used the steps from your file. It solved my problem. Thanks @davehus 

[davehus · Accepted solution]

Hi @DBricklin1979 ,

Please find a solution below.

Did I help you today? Please accept my solution and hit the Kudos button.

[DBricklin1979]

Thanks @davehus ! But I am not sure how to use the BI-file you sent me. Can I open it in Excel?