after you split the data you have 3 (or more dimensions (columns) of Course number course ID data - you can Pivot the data around the student ID to form a long (tall ) single column of course ID by student ID - then you can eliminate the nulls (there will be plenty based on your example) and your daata will be ready for Tableau where you can count d the course numbers by student
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
I have a similar issue, but the number of columns results from the split is dynamic and could grow in the future. Is there a way to dynamically pivot so I can include all of the split results in the pivot to get nice, normalized data?