title: How to pivot a category-column to individual columns per category
body: <p>I have been playing with this Rubix-cube of a power query problem for long enough and concede defeat.</p>
  <p>I have a table with values which look like this:</p>
  <pre><code>Category | Date     | Lead Ref | Values
  ---------+----------+----------+---------
  Cat A    | Jan 2020 | 1234A    | 11,111
  Cat B    | Jan 2020 | 1234A    | TextOne
  Cat C    | Jan 2020 | 1234A    | 33
  </code></pre>
  <p>But I want to pivot the Category column so it creates two additional columns and takes the corresponding Values with it. For example:</p>
  <pre><code>Date     | Lead Ref | Cat A   | Cat B   | Cat C
  ---------+----------+---------+---------+-------
  Jan 2020 | 1234A    | 11,111  | TextOne | 33
  </code></pre>
  <p>Any help appreciated!</p>
  <p>Thanks</p>
  <p>Paul</p>