title: Power BI - Create a column to show the data against one item
body: <p>I have a table with repeating values in a single column, I am trying to filter the data corresponding to just one value. I have tried Pivoting the table and it didn't help, it would be helpful to get the solution using DAX or Power Query.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>S.No.</th>
  <th>Make</th>
  <th>Sale Date</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>Mercedes</td>
  <td>01.08.2020</td>
  </tr>
  <tr>
  <td>2</td>
  <td>BMW</td>
  <td>02.08.2020</td>
  </tr>
  <tr>
  <td>3</td>
  <td>Hyundai</td>
  <td>03.09.2020</td>
  </tr>
  <tr>
  <td>4</td>
  <td>Honda</td>
  <td>04.06.2020</td>
  </tr>
  <tr>
  <td>5</td>
  <td>BMW</td>
  <td>16.03.2020</td>
  </tr>
  <tr>
  <td>6</td>
  <td>BMW</td>
  <td>06.08.2020</td>
  </tr>
  <tr>
  <td>7</td>
  <td>Mercedes</td>
  <td>01.02.2021</td>
  </tr>
  <tr>
  <td>8</td>
  <td>Honda</td>
  <td>18.08.2020</td>
  </tr>
  <tr>
  <td>9</td>
  <td>BMW</td>
  <td>12.04.2020</td>
  </tr>
  <tr>
  <td>10</td>
  <td>Honda</td>
  <td>10.03.2021</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I need each Make to display their own Sale Date's in their own column similar to the table below</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>BMW</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>02.08.2020</td>
  </tr>
  <tr>
  <td>16.03.2020</td>
  </tr>
  <tr>
  <td>06.08.2020</td>
  </tr>
  <tr>
  <td>12.04.2020</td>
  </tr>
  </tbody>
  </table>
  </div>