Power Query: Creating ordered table from multiple columns based on left column

[Viau1337]

Hello! I have just discovered power query for something I am doing and have been trying to set something of this sort:

I have a query with two columns, one of them is called Topic, the other Sub Topic
Topics each have a couple of sub topics within them

I'm trying to convert it with a power query to a table that will sort them a bit like so:

Anyway I can get some help on this?
I'm using power query because there may be new topics and sub topics added eventually and want them to automatically update due to multiple formulas that are based on this table.

Thanks!

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    tbl = Table.Group(Source, {"Topic"}, {{"All", each List.Sort([Sub Topic])}}),
    tbl1 = Table.Sort(tbl,{{"Topic", Order.Ascending}}),
    Result = Table.FromColumns(tbl1[All], tbl1[Topic])
in
    Result

Book1
	A	B	C	D	E	F	G
1	Topic	Sub Topic		A	B	C
2	B	9		1	2	4
3	B	6		7	3	5
4	A	11		11	6	12
5	B	3			8
6	C	12			9
7	B	10			10
8	A	1
9	C	4
10	C	5
11	B	8
12	A	7
13	B	2
14
Sheet2

 

[Viau1337]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    tbl = Table.Group(Source, {"Topic"}, {{"All", each List.Sort([Sub Topic])}}),
    tbl1 = Table.Sort(tbl,{{"Topic", Order.Ascending}}),
    Result = Table.FromColumns(tbl1[All], tbl1[Topic])
in
    Result

Book1
	A	B	C	D	E	F	G
1	Topic	Sub Topic		A	B	C
2	B	9		1	2	4
3	B	6		7	3	5
4	A	11		11	6	12
5	B	3			8
6	C	12			9
7	B	10			10
8	A	1
9	C	4
10	C	5
11	B	8
12	A	7
13	B	2
14
Sheet2

OMG Thank you so much!! I had went and created a bunch of connections just to arrive to that result, that makes it much easier!