EVERY 2nd and 3rd row to new column Power BI/Power Query

[MikeL]

Hi,
I want to make 1 column into 3 columns, with less rows

type

a

b

c

a1

b1

c1

a2

b2

c2

 

[MikeL]

Expected Output

type	col2	col3
a	b	c
a1	b1	c1
a2	b2	c2

 

[alansidman]

Power Query Mcode

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Added Index" = Table.AddIndexColumn(Source, "Index", 1, 1, Int64.Type),
    #"Inserted Modulo" = Table.AddColumn(#"Added Index", "Modulo", each Number.Mod([Index], 3), type number),
    #"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Inserted Modulo", {{"Modulo", type text}}, "en-US"), List.Distinct(Table.TransformColumnTypes(#"Inserted Modulo", {{"Modulo", type text}}, "en-US")[Modulo]), "Modulo", "type"),
    #"Filled Up" = Table.FillUp(#"Pivoted Column",{"2", "0"}),
    #"Filtered Rows" = Table.SelectRows(#"Filled Up", each ([1] <> null)),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Index"})
in
    #"Removed Columns"

Book5
	A	B	C	D	E
1	type		1	2	0
2	a		a	b	c
3	b		a1	b1	c1
4	c		a2	b2	c2
5	a1
6	b1
7	c1
8	a2
9	b2
10	c2
Sheet1