title: Trying breakup group data and sort them according to respective columns
body: <p>I'm quite new to VBA. For each group shown below, I am trying to sort this data into a table where I can see if the student has been a part of a certain group or not. I have screenshotted the table where I am starting at, and the the second screenshot shows the table that I am trying to populate. If the student has been in the group or not, I want the table to write &quot;exists&quot; where the student has been a group member of.</p>
  <p>Here's where the data that I am starting with.</p>
  <p><a href="https://i.stack.imgur.com/99t36.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/99t36.png" alt="enter image description here" /></a></p>
  <p>Here's the table for which that I am trying to populate:</p>
  <p><a href="https://i.stack.imgur.com/4IxVY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4IxVY.png" alt="enter image description here" /></a></p>