title: Remove duplicates from single column power query
body: <p>From this original table,</p>
  
  <p><a href="https://i.stack.imgur.com/UxGaT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UxGaT.png" alt="enter image description here"></a></p>
  
  <p>I made a second table (using power query).</p>
  
  <p><a href="https://i.stack.imgur.com/YdX9g.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YdX9g.png" alt="enter image description here"></a></p>
  
  <p>This second table is to be used for data validation purposes, and I need it to depend on the first table so that any changes will follow through. The problem I'm running into is that my second table is not quite how I want it, I would like to remove any duplicates from each individual column. When I try to remove duplicates in power query, it removes whole rows (which makes sense, I agree), is there a way to remove duplicates from single columns? </p>
  
  <p>Here's the M code I'm using to get from table1 to table2</p>
  
  <pre><code>let
  Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
     #"Removed Columns" = Table.RemoveColumns(Source,{"Grade", "fb", "fv", "fc", "fcp", "ft", "E", "E05"}),
     #"Grouped Rows" = Table.FromColumns(Table.Group(#"Removed Columns", {"Catégorie"}, {{"Count", each List.InsertRange([Essence],0,List.Distinct([Catégorie]))}})[Count]),
     #"Promoted Headers" = Table.PromoteHeaders(#"Grouped Rows", [PromoteAllScalars=true])
  in 
     #"Promoted Headers"
  </code></pre>