Unstack data in power query

[Excel202201]

I am new to Power Query, and trying to transform the following data to table. Watched few Youtube which only has one column in the example, but this one has three columns. How do I do it, I add the index column, Modulo column, then what's next? Help please

Customer #	City	State
75​	Toronto	ON
Loan #	Loan Rate	Loan Balance
25​	2.10%​	121,876
Approved Date	Maturity Date	Branch Code
2017-01-01​	2017-04-01​	12967​
Customer #	City	State
76​	Mississauga	ON
Loan #	Loan Rate	Loan Balance
26​	2.20%​	112,701
Approved Date	Maturity Date	Branch Code
2017-01-06​	2017-04-06​	12710​
Customer #	City	State
77​	Ottawa	ON
Loan #	Loan Rate	Loan Balance
27​	2.75%​	114,390
Approved Date	Maturity Date	Branch Code
2017-01-11​	2017-04-11​	11809​
Customer #	City	State
78​	Hamilton	ON
Loan #	Loan Rate	Loan Balance
28​	2.10%​	61,597
Approved Date	Maturity Date	Branch Code
2017-01-16​	2017-04-16​	13735​

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    hdrs = List.Accumulate({0,2,4}, {}, (s,c)=> s & {Record.ToList(Source{c})}),
    tcn = List.Combine(hdrs),
    tbl = Table.SelectRows(Source, each not List.Contains(hdrs, Record.ToList(_))),
    tbl1 = Table.AddIndexColumn(tbl, "Index", 0, 1, Int64.Type),
    tbl2 = Table.TransformColumns(tbl1, {{"Index", each Number.IntegerDivide(_ +.5,3)}}),
    tbl3 = Table.Group(tbl2, {"Index"}, {{"All", each Table.FromRows({List.Combine(Table.ToRows(Table.SelectColumns(_, {"Column1","Column2", "Column3"})))}, tcn)}}),
    tbl4 = Table.RemoveColumns(tbl3,{"Index"}),
    Result = Table.ExpandTableColumn(tbl4, "All", tcn)
in
    Result

PQ Unstack1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Column1	Column2	Column3		Customer #	City	State	Loan #	Loan Rate	Loan Balance	Approved Date	Maturity Date	Branch Code
2	Customer #	City	State		75	Toronto	ON	25	2.10%	121876	2017-01-01	2017-04-01	12967
3	75	Toronto	ON		76	Mississauga	ON	26	2.20%	112701	2017-01-06	2017-04-06	12710
4	Loan #	Loan Rate	Loan Balance		77	Ottawa	ON	27	2.75%	114390	2017-01-11	2017-04-11	11809
5	25	2.10%	121876		78	Hamilton	ON	28	2.10%	61597	2017-01-16	2017-04-16	13735
6	Approved Date	Maturity Date	Branch Code
7	2017-01-01	2017-04-01	12967
8	Customer #	City	State
9	76	Mississauga	ON
10	Loan #	Loan Rate	Loan Balance
11	26	2.20%	112701
12	Approved Date	Maturity Date	Branch Code
13	2017-01-06	2017-04-06	12710
14	Customer #	City	State
15	77	Ottawa	ON
16	Loan #	Loan Rate	Loan Balance
17	27	2.75%	114390
18	Approved Date	Maturity Date	Branch Code
19	2017-01-11	2017-04-11	11809
20	Customer #	City	State
21	78	Hamilton	ON
22	Loan #	Loan Rate	Loan Balance
23	28	2.10%	61597
24	Approved Date	Maturity Date	Branch Code
25	2017-01-16	2017-04-16	13735
26
Sheet2

 

[Excel202201]

Thank you so much! Do you have another way to do it? the requirement I have is to use Index, Modulo Column and if statement.