join - Need to seperate data in Cell D5 then add it to a new sheet

Question

I have a spreadsheet that has music titles in Cell A1 and in Cell B1; I have different names of people that have songs, all separated with a ;. What I would like to do is have a new spreadsheet that has all the data on separate lines.

Original:

What I want it to look like:

I am hoping to use a VBA script but am open to other options. At the moment, I have over 2500 singles that I would like to sort.

question from:https://stackoverflow.com/questions/65875214/need-to-seperate-data-in-cell-d5-then-add-it-to-a-new-sheet

Answer 1

Waitting for answers