Combining cascading relationship into a single table in excel

[ajaysomasi]

Hi all,

I really need help here.. I have Level 1, Level 2, Level 3 columns, each interrelated as shown below.. I'd like to produce an output as shown below.. I'm using some dummy data here but the dataset I have is large in size, hence I am not thinking of formula-based approach but like to use a Power Query or similar (in the excel environment) which can give me an output.. IF I use formula based approach, the excel file size becomes large and doesnt respond.. Really appreciate your help..

INPUT

Level 1 (Header)

A

B

Level 1 (Header)	Level 2 (Header)
A	1
A	2
B	3
B	4

Level 2 (Header)	Level 3 (Header)
1	a
1	b
2	c
2	d
3	e
3	f
4	g
4	h

OUTPUT

Level 1 (Header)	Level 2 (Header)	Level 3 (Header)
A	1	a
A	1	b
A	2	c
A	2	d
B	3	e
B	3	f
B	4	g
B	4	h

 

[JGordon11]

let
    L2 = Excel.CurrentWorkbook(){[Name="tblL2"]}[Content],
    L3 = Excel.CurrentWorkbook(){[Name="tblL3"]}[Content],
    tbl = Table.Group(L3, {"Level 2"}, {{"Level 3", each _[Level 3]}}),
    tbl1 = Table.Join(L2,"Level 2", tbl, "Level 2"),
    Result = Table.ExpandListColumn(tbl1, "Level 3")
in
    Result

Book1
	A	B	C	D	E	F	G
1	Level 1	Level 2		Level 1	Level 2	Level 3
2	A	1		A	1	a
3	A	2		A	1	b
4	B	3		A	2	c
5	B	4		A	2	d
6				B	3	e
7	Level 2	Level 3		B	3	f
8	1	a		B	4	g
9	1	b		B	4	h
10	2	c
11	2	d
12	3	e
13	3	f
14	4	g
15	4	h
16
Sheet7

 

[ajaysomasi]

Thanks JGordon11..