Table organisation and row elimination

[ALVMRB]

Hi everyone I have the next data :

JON	0
MAR	1
JUAN	0
ALF	1
ALF	1
PEP	0
PEP	0
VA	0
VA	0
PA	0
PA	1
CTA	1
CTA	1
AR	0
NSA	1
NSA	1

I would like to do the next things: eliminate rows with 0 and eliminate rows that have a repeated name, I´ve tried many ways in different order. However, I don´t have a effective way, I would be please if some helped me to solve this problem.

Thanks for reading

[lbendlin · Accepted solution]

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8vL3U9JRMlCK1YlW8nUMArINwWyvUEeEhKOPG1wCmR3gGgBXg8wOc8TGDEBjQsxwDsHOBrsFotovGCEMZ8cCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Item = _t, Value = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Item", type text}, {"Value", Int64.Type}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Value] <> 0)),
    #"Removed Duplicates" = Table.Distinct(#"Filtered Rows", {"Item"})
in
    #"Removed Duplicates"

How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done". Once you examined the code, replace the Source step with your own source.