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:

Split

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

Your output

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).