Split data in cells and duplicate rows

[ballpoint]

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:

QuoteID | QuoteContent | Document | Cited References

Quote1  | lorem ipsum... | Doc1 | Reference1, Reference2, Reference3

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:

QuoteID | QuoteContent | Document | Cited References

Quote1  | lorem ipsum... | Doc1 | Reference1
Quote1  | lorem ipsum... | Doc1 | Reference2
Quote1  | lorem ipsum... | Doc1 | Reference3

Is there any way to do it?

Thank you ever so much!