One Column of Data to Multiple Columns of Data

[Matthew Hedge]

Hi,

Could some show how to achieve this in power query? What steps to take to transform one column of data to multiple columns? Thank you.

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Result = Table.FromRows(List.Split(Source[Column1],3))
in
    Result

Book1
	A	B	C	D	E	F
1	Table1		Query Output
2	Column1		Column1	Column2	Column3
3	A		A	B	C
4	B		D	E	F
5	C		G	H	I
6	D		J	K	L
7	E		M	N	O
8	F		P	Q	R
9	G
10	H
11	I
12	J
13	K
14	L
15	M
16	N
17	O
18	P
19	Q
20	R
21
Sheet1