There are ways we can do this in Tableau, like creating a Calc for each Organizations Affiliated, but your best bet here would be to clean up the data in the format you need prior to importing into Tableau.
I would suggest creating a single row for each Organizations Affiliated, instead of splitting them into different columns. This will give you the most flexibility.
After you split the data in tableau, you should have most of what you need. You would be able to reproduce the view (based on that image) in tableau by putting Name, State, City on Rows, and your new Organization field on Columns. A column would be generated for every Organization, and you could then put something you want to see on Text.
To learn how to populate cells that do not have values, see:
If you'd like a sample, please make a sample packaged workbook with data how you have in your image and upload it here.
When Tableau "splits" the data, it is not creating a New Row for each item, but a new column.
You need all of these Organizations Affiliated to be in a single column in order to do what you want.
I think I can understand how to work on this problem from everyone's help.
I just wanted to make sure there wasn't a quick fix that did this sort of problem.
Thank you very much.
I really appreciate it.