title: Group rows content by id
body: <p>Suppose I have a number of checks for analysis looking like this:</p>
  
  <pre><code>Check_ID Category Items Cost
    000      Sugar     1     1
    001      Milk      1    10
    001      Butter    2    20
    001      Bread     1     5
  </code></pre>
  
  <p>and I want to make it look the following without manually setting the number of rows:</p>
  
  <pre><code>Check_ID Category.1 Items Cost Category.2 Items Cost Category.3 Items Cost
    000      Sugar      1     1
    001      Milk       1    10    Butter     2     20   Bread      1     5
  </code></pre>
  
  <p>I need to understand which products are usually taken together. Maybe there's an alternative solution, but I'm pretty stuck.</p>
  
  <p>Thanks in advance.</p>