title: Dynamic Pivot Column by Substring
body: <p>I have this table:</p>
  
  <pre><code>itemid                  attributename   value
  6829556334057807840       Part Notes    Drilling Required: No,Install Time: 30 Minutes,Fascia Trimming: Yes (minor),Visibility: Exposed
  </code></pre>
  
  <p>I want to be able to pivot the data in the Value column to a KeyValue pair</p>
  
  <pre><code>Example:
  
      ItemId                  Key                  Value
  6829556334057807840       Drilling Required       No
  6829556334057807840       Install Time            30
  6829556334057807840       Fascia Trimming         Yes (minor)
  </code></pre>
  
  <p>However the pivot must be dynamic because the Value column can have multiple different Key Values depending what is in the column. </p>