Separate comma-delimited values to rows

I have tried doing this myself, cloning parts and pieces from others, but can not get it to work right.

I have an excel sheet I create with lots of inventory items distributed amongst several locations. The first column is a location field where several 1-2 digit location codes are seperated by commas. I would love to get the macro to copy each row, once for each location code, onto a new tab as a new longer list. Because the amount of data per row varies, I need the entire row to be copied to the new tab.

EX:
GOING FROM THIS...
LOC ITEM etc...
1, 2, 5 ITEM1 moredata...
1, 5, 10 ITEM2 moredata2...

TO THIS ON NEW TAB...
LOC ITEM etc...
1 ITEM1 moredata...
2 ITEM1 moredata...
5 ITEM1 moredata...
1 ITEM2 moredata2...
5 ITEM2 moredata2...
10 ITEM2 moredata2...