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"