title: How do I remove duplicates WITHIN a row using Power Query?
body: <p>I have data that looks like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Wire</th>
  <th>Point1</th>
  <th>Point2</th>
  <th>Point3</th>
  <th>Point4</th>
  <th>Point5</th>
  <th>Point6</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>A</td>
  <td>WP1</td>
  <td>WP1</td>
  <td>WP2</td>
  <td></td>
  <td></td>
  <td>WP2</td>
  </tr>
  <tr>
  <td>B</td>
  <td>WP3</td>
  <td>WP4</td>
  <td>WP3</td>
  <td></td>
  <td></td>
  <td>WP4</td>
  </tr>
  <tr>
  <td>C</td>
  <td>WP5</td>
  <td>WP5</td>
  <td>WP6</td>
  <td>WP7</td>
  <td>WP6</td>
  <td>WP7</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>(note the varying lengths of each row, and the duplicates)</p>
  <p>I would like to have the end result be:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Wire</th>
  <th>Point1</th>
  <th>Point2</th>
  <th>Point3</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>A</td>
  <td>WP1</td>
  <td>WP2</td>
  <td></td>
  </tr>
  <tr>
  <td>B</td>
  <td>WP3</td>
  <td>WP4</td>
  <td></td>
  </tr>
  <tr>
  <td>C</td>
  <td>WP5</td>
  <td>WP6</td>
  <td>WP7</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Duplicates removed, and blank spaces removed.</p>
  <p>This would be VERY similar to the =UNIQUE() function, but that is not available in power query.</p>