PQ - Extracting data from range

PRODUCT CODE	PRODUCT NAME	SALES	SALES RANK %		PRODUCT NAME	SALES RANK %
	UNITED KINGDOM				UNITED KINGDOM	25
AAA	PRODUCT AAA	100	99		UNITED STATES	76
BBB	PRODUCT BBB	200	75		SPAIN	17
CCC	PRODUCT CCC	300	43		JAPAN	121
	Count		25
	UNITED STATES
DDD	PRODUCT DDD	400	82
EEE	PRODUCT EEE	500	67
	Count		76
	SPAIN
FFF	PRODUCT FFF	600	73
GGG	PRODUCT GGG	700	35
HHH	PRODUCT HHH	800	26
	Count		17
	JAPAN
III	PRODUCT III	900	92
JJJ	PRODUCT JJJ	1000	53
KKK	PRODUCT KKK	1100	39
LLL	PRODUCT LLL	1200	5
	Count		121

Code:

---

// Table1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Filtered Rows" = Table.SelectRows(Source, each ([PRODUCT NAME] = "Count" or [PRODUCT NAME] = "JAPAN" or [PRODUCT NAME] = "SPAIN" or [PRODUCT NAME] = "UNITED KINGDOM" or [PRODUCT NAME] = "UNITED STATES")),
    #"Filled Up" = Table.FillUp(#"Filtered Rows",{"SALES RANK %"}),
    #"Filtered Rows1" = Table.SelectRows(#"Filled Up", each ([PRODUCT NAME] <> "Count")),
    #"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows1",{"PRODUCT NAME", "SALES RANK %"})
in
    #"Removed Other Columns"

---