Solved: Parse cell data into seperate columns

[grichey]

Here's a better example maybe. I'm trying to get to the desired outcome via macro without having all the formulas just loaded in because the number of Subjects might change.