The only way I can think of right now is, to perform the split on your original data source and then copy all the data and paste it on a new excel workbook. Bring the data back in Tableau and do a pivot on the splits:
Copy data in excel
again conect excel data in tableau and pivot
Delete unwanted columns
Rename the Pivot field values to "People" and put data source filter to ignore null values.
Final view of data
Although this is not the best way to do it because if the data changes at the source level, you will have to re-do this process. If there is however, a one time need to show the data the way you described, this might just work fine. Try to transpose your data at source level first. like the screen shot (final view of data).
workbook (version 9.2) attached for your reference.
Data transpose.twbx 8.3 KB
I was really hoping not to have to reshape the data but it looks like its going to be the easiest way.
Thanks for the help everyone