Power Query question - how to separate out a specific row into its own column?

[ExcelOnTheClock]

Hi folks--I have a table structured like below:

I want to put Communication Services and Consumer Discretionary into their own column, so then I can fill down and aggregate these stocks. Is there a way to do this in Power Query? Preferably without using the Advanced Editor? If the Advanced Editor is required that's totally fine. My coworkers are intimidated by the advanced editor, so if can show them how to do this with just mouse clicks, that's always ideal. I want it to look like this:

The data lives HERE, let me know if the link doesn't work.

Thanks in advance for any help!

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    tbl1 = Table.FillDown(Table.AddColumn(Source, "Sector", each if Text.Length([Identifier]) <= 5 then null else [Identifier]),{"Sector"}),
    tbl2 = Table.ReorderColumns(tbl1,{"Identifier", "Sector", "Weight"}),
    Result = Table.SelectRows(tbl2, each Text.Length([Identifier]) <= 5)
in
    Result

Book1
	A	B	C	D	E	F	G
1	Identifier	Weight		Identifier	Sector	Weight
2	Communication Services	94.20%		META	Communication Services	0.1944
3	META	19.44%		GOOGL	Communication Services	0.1815
4	GOOGL	18.15%		GOOG	Communication Services	0.1593
5	GOOG	15.93%		DIS	Communication Services	0.073
6	DIS	7.30%		VZ	Communication Services	0.0655
7	VZ	6.55%		CMCSA	Communication Services	0.0635
8	CMCSA	6.35%		NFLX	Communication Services	0.0611
9	NFLX	6.11%		T	Communication Services	0.0564
10	T	5.64%		TMUS	Communication Services	0.0353
11	TMUS	3.53%		ATVI	Communication Services	0.0242
12	ATVI	2.42%		CHTR	Communication Services	0.0145
13	CHTR	1.45%		EA	Communication Services	0.0132
14	EA	1.32%		AMZN	Consumer Discretionary	0.2668
15	Consumer Discretionary	75.16%		TSLA	Consumer Discretionary	0.1461
16	AMZN	26.68%		HD	Consumer Discretionary	0.087
17	TSLA	14.61%		MCD	Consumer Discretionary	0.0619
18	HD	8.70%		NKE	Consumer Discretionary	0.0461
19	MCD	6.19%		SBUX	Consumer Discretionary	0.036
20	NKE	4.61%		LOW	Consumer Discretionary	0.0356
21	SBUX	3.60%		BKNG	Consumer Discretionary	0.0298
22	LOW	3.56%		TJX	Consumer Discretionary	0.0261
23	BKNG	2.98%		ORLY	Consumer Discretionary	0.0162
24	TJX	2.61%
25	ORLY	1.62%
26
Sheet2

 

[ExcelOnTheClock]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    tbl1 = Table.FillDown(Table.AddColumn(Source, "Sector", each if Text.Length([Identifier]) <= 5 then null else [Identifier]),{"Sector"}),
    tbl2 = Table.ReorderColumns(tbl1,{"Identifier", "Sector", "Weight"}),
    Result = Table.SelectRows(tbl2, each Text.Length([Identifier]) <= 5)
in
    Result

Book1
	A	B	C	D	E	F	G
1	Identifier	Weight		Identifier	Sector	Weight
2	Communication Services	94.20%		META	Communication Services	0.1944
3	META	19.44%		GOOGL	Communication Services	0.1815
4	GOOGL	18.15%		GOOG	Communication Services	0.1593
5	GOOG	15.93%		DIS	Communication Services	0.073
6	DIS	7.30%		VZ	Communication Services	0.0655
7	VZ	6.55%		CMCSA	Communication Services	0.0635
8	CMCSA	6.35%		NFLX	Communication Services	0.0611
9	NFLX	6.11%		T	Communication Services	0.0564
10	T	5.64%		TMUS	Communication Services	0.0353
11	TMUS	3.53%		ATVI	Communication Services	0.0242
12	ATVI	2.42%		CHTR	Communication Services	0.0145
13	CHTR	1.45%		EA	Communication Services	0.0132
14	EA	1.32%		AMZN	Consumer Discretionary	0.2668
15	Consumer Discretionary	75.16%		TSLA	Consumer Discretionary	0.1461
16	AMZN	26.68%		HD	Consumer Discretionary	0.087
17	TSLA	14.61%		MCD	Consumer Discretionary	0.0619
18	HD	8.70%		NKE	Consumer Discretionary	0.0461
19	MCD	6.19%		SBUX	Consumer Discretionary	0.036
20	NKE	4.61%		LOW	Consumer Discretionary	0.0356
21	SBUX	3.60%		BKNG	Consumer Discretionary	0.0298
22	LOW	3.56%		TJX	Consumer Discretionary	0.0261
23	BKNG	2.98%		ORLY	Consumer Discretionary	0.0162
24	TJX	2.61%
25	ORLY	1.62%
26
Sheet2

Awesome, thank you so much! It works.