title: Pivot Different Prices for the Same Item
body: <p>I have a need to show different prices for the same product where the client wants to understand discrepancies in same region. The source table looks like below</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Item</th>
  <th>Brand</th>
  <th>Concept</th>
  <th>Price</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>00A</td>
  <td>A</td>
  <td>Alpha</td>
  <td>1</td>
  </tr>
  <tr>
  <td>00B</td>
  <td>A</td>
  <td>Alpha</td>
  <td>1</td>
  </tr>
  <tr>
  <td>00B</td>
  <td>A</td>
  <td>Alpha</td>
  <td>2</td>
  </tr>
  <tr>
  <td>00B</td>
  <td>A</td>
  <td>Beta</td>
  <td>3</td>
  </tr>
  <tr>
  <td>00A</td>
  <td>B</td>
  <td>Alpha</td>
  <td>1</td>
  </tr>
  <tr>
  <td>00B</td>
  <td>B</td>
  <td>Alpha</td>
  <td>1</td>
  </tr>
  <tr>
  <td>00B</td>
  <td>B</td>
  <td>Beta</td>
  <td>2</td>
  </tr>
  <tr>
  <td>00B</td>
  <td>B</td>
  <td>Alpha</td>
  <td>3</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>The output I am trying to achieve is a little complicate but can be simplified if we only focus on Brand A so please consider i am pivoting for Brand A only. Result Needed is</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Item</th>
  <th>Alpha</th>
  <th></th>
  <th>Beta</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>00A</td>
  <td>1</td>
  <td>Null</td>
  <td>Null</td>
  </tr>
  <tr>
  <td>00B</td>
  <td>1</td>
  <td>2</td>
  <td>3</td>
  </tr>
  </tbody>
  </table>
  </div>