I apologise if this question has been asked before, but I have not been able to find a satisfactory answer. So I thought I'd ask it here.

I have a set of data which is structured this way:

What I need to do is to

1. Split the data in the last cell at the comma or other separator
2. Duplicate rows with rest of the data

In practice, the data should then look like this:

Is there any way to do it?

Thank you ever so much!