Changing data format from several columns to one appended column

Hello, I have some data that has appointments and a delimited list of users for said appointment in one column. I can split out the attendees into individual columns but I want to then be able to cou...