Automate Splitting up locations in a cell into new rows? Seems simple but not sure

Hi all!

I have a problem where I've accidentally combined a bunch of locations in one cell of a row, when infact each location was supposed to be a seperate row but retaining the same details/data of the rest of the row. Even sharing the same ID for each location on each row. EAch location is seperated by a comma.

This is how it is now with location (Before):

\1



This is how I"m trying to get it to look for all rows (this only showing A1 as an example)

\1



Here is the file itself with both before and after tabs

Excel problem.xlsx

I"m not sure if this is even possible. Any help is appreciated =)

I"m really terrible at explaining things so if something makes no sense please let me know. I"m really praying that there is a better way than just to do it manually =(

see the attached file; 2 helper columns created in both the sheets

thanks for your feedback and words