Append contents of one column to another in Power Query

[datatronics505]

Hi,
I am stuck at appending contents of one column to another in Power Query. In the simplest of examples:

Column1	Column2
abc	def

should turn into:

Column1

abc

def

Again, in Power Query.

 

[datatronics505]

Why do you expect that to return an error?

It works the same as you we're to go split that single line into multiple ones:

T2L = Table.ToColumns(Source),
L = List.Combine(T2L),
L2T = Table.FromColumns(L)

You don't have any other arguments in Table.ToColumns(Source) beside Source. My expectation for an error was when I didn't see the Source as the first argument to a method of the step subsequent to Source.

 

[jdellasala]

Hi,
I am stuck at appending contents of one column to another in Power Query. In the simplest of examples:

Column1	Column2
abc	def

should turn into:

Column1

abc

def

Again, in Power Query.

Try Merge Columns, and post data with XL2BB!

 

[Automatrix]

Here's an alternative that only uses "point and click" steps. I add a custom column (=1), then unPivot the two other columns.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Added Custom" = Table.AddColumn(Source, "Custom", each 1),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Added Custom", {"Custom"}, "Attribute", "Value"),
    #"Removed Columns" = Table.RemoveColumns(#"Unpivoted Columns",{"Custom", "Attribute"})
in
    #"Removed Columns"