title: How do I transform this dataset to not include counterbalancing?
body: <p>If I have a dataset like this :</p>
  <p><a href="https://i.stack.imgur.com/lbdnX.png" rel="nofollow noreferrer">sample dataset</a></p>
  <p>How do I transform the dataset to make something exactly like this?</p>
  <p><a href="https://i.stack.imgur.com/Y7p0K.png" rel="nofollow noreferrer">what I am looking for</a></p>
  <p>I was thinking of using pivot_longer() but I don't really know where to start at all.</p>
  <p>If someone could help with this, it would be much appreciated.</p>