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.
1.4m articles
1.4m replys
5 comments
57.0k users