Splitting Enumlist string into list

[hen_yu]

I used a combination of Enumlist and Valid_if to allow multiple selection in my dropdown menu. However, this made the multiple selection into a string instead of a list.

In excel, i am getting the following

Name Time In Time Out Total
John W, Michael L, Peter S, Laural L 6:00 PM 8:53 PM 2:53HR

But i want it to be the following,

Name Time In Time Out Total
John W 6:00 PM 8:53 PM 2:53HR
Michael L 6:00 PM 8:53 PM 2:53HR
Peter S 6:00 PM 8:53 PM 2:53HR
Laural L 6:00 PM 8:53 PM 2:53HR

Does anyone have a suggestion to automate this either in excel or appsheet?

Thanks