title: Remove Duplicates in Power Query WITHOUT Removing Entire Row
body: <p><a href="https://i.stack.imgur.com/8BvPR.png" rel="nofollow noreferrer">enter image description here</a>I need to remove duplicates in multiple columns without removing the entire row. I have a Query with multiple columns and there are 6 columns I want to remove duplicates from. The column headers are:</p>
  <p>&quot;Unforcasted Orders&quot;
  &quot;Forecasted Orders&quot;
  &quot;Forecasted and Unforcasted&quot;
  &quot;Open Orders&quot;
  &quot;Capability&quot;
  &quot;Actuals&quot;</p>
  <p>My previous applied step is &quot;Reordered Columns2&quot;.
  What is the M code for this? Thanks in advance.</p>
  <p>I cannot group by because each &quot;Forecast Date&quot; is for a given month and with that month it corresponds to multiple months as &quot;Month in Forecast&quot;. If I cannot remove these duplicates without removing the entire row, is there a way to replace the duplicates with null or make them blank? Thanks.</p>