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

 

[billszysz]

let
  Source = Table.FromColumns(
    {
      List.RemoveNulls(
        List.Combine(Table.ToColumns(Excel.CurrentWorkbook(){[Name = "Table1"]}[Content]))
      )
    },
    {"Result"}
  )
in
  Source

 

[GerryZ]

Hello Thank you for the answer but i get error
probably i make some mistake
Is possible to do with UI or where do you put your M code?
can you post the file so i can see

 

[billszysz]

No problem )
Link to file

 

[GerryZ]

Nice, I wish to understand..... how you did this? with UI o you wrote a formula, can you show all the steps

 

[sandy666]

another approach with most steps from user interface except one

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    TTC = Table.ToColumns(Source),
    C2T = Table.FromList(TTC, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    Exp = Table.ExpandListColumn(C2T, "Column1"),
    FilterNull = Table.SelectRows(Exp, each ([Column1] <> null))
in
    FilterNull

 

[GerryZ]

Hello sandy666
Your approach with user Interface is much better, but I'm not able to adjust the formula il my example
i have sintax error, i don't know where I make mistake
How can I add this line of Mcode?

TTC = Table.ToColumns(Source),

was nice to watch a short video with all the steps you did

Thank you

 

[GerryZ]

Because i'm tryng to learn, and not just solve the problem

 

[sandy666]

Could you post your M-code even if there is an error?

open Advanced Editor and type this manually

then you can create next steps with GUI

also you can read:

• What is PowerQuery
• Getting started with PQ
• PowerQuery Help
• PowerQuery M reference

 

[GerryZ]

Ok Thank You I did it
Great job
Thank you