Power Query question - how to append two existing columns to be under 2 other columns?

[ExcelOnTheClock]

Hello,

How can I get columns 3 and 4 to be below columns 1 and 2?

If it's possible to do this without using custom M code, that would be ideal! All good if I have to though.

Thanks in advance for any help!

 

[JEC]

You need some custom code

 

[ExcelOnTheClock]

You need some custom code

Shoot. I was thinking I could duplicate the two tables then delete the columns, then recombine?

 

[RoryA]

Yes you can do that.

 

[JEC]

You can indeed create a duplicate table. Here another solution.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    colNames = {{"Column1", "Column2"},{"Column3", "Column4"}},
    FirstTwo = Table.SelectColumns(Source,colNames{0}),
    LastTwo = Table.RenameColumns(Table.SelectColumns(Source,colNames{1}), List.Zip({colNames{1},colNames{0}})),
    result = Table.Combine({FirstTwo,LastTwo})
in
    result

Book1
	A	B	C	D
1	Column1	Column2	Column3	Column4
2	a	1	d	4
3	b	2	e	5
4	c	3	f	6
5
6
7	Column1	Column2
8	a	1
9	b	2
10	c	3
11	d	4
12	e	5
13	f	6
Sheet1

 

[ExcelOnTheClock]

You can indeed create a duplicate table. Here another solution.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    colNames = {{"Column1", "Column2"},{"Column3", "Column4"}},
    FirstTwo = Table.SelectColumns(Source,colNames{0}),
    LastTwo = Table.RenameColumns(Table.SelectColumns(Source,colNames{1}), List.Zip({colNames{1},colNames{0}})),
    result = Table.Combine({FirstTwo,LastTwo})
in
    result

Book1
	A	B	C	D
1	Column1	Column2	Column3	Column4
2	a	1	d	4
3	b	2	e	5
4	c	3	f	6
5
6
7	Column1	Column2
8	a	1
9	b	2
10	c	3
11	d	4
12	e	5
13	f	6
Sheet1

Okay thank you for the help! I'll give this code a shot too.