Comma Delim to Rows - Everything Else Copied

Hey Guys/Girls,

I have a spreadsheet of data that contains multiple item numbers (one per row) and one column in that list (Column C) has comma-delim data (2 characters).

It's currently taking 3 employees 2 whole days to sift through this report in order to extract what they need. If we are able to take this data (attached) and blow it out so that we create separate rows for each of the Item - Patch combinations, it would save a ton of work.

To summarize, I need a way to take all of the comma-delim 2-digit codes in Column C and make them go to one in each row, but also copy all of the data from the row it's in to the single row. I have attached a file that shows our current data set, and then below that, an example of what I want the data to look like after the macro is completed.

Finally, the actual data set is 2,455 rows long before I would run the macro so the result could potentially be 400-500,000 rows of data. Also, I would need all columns to be copied over since all columns are used at some point in the data.

P.S. I would like the macro to create the result in a new tab if at all possible.

Thanks so much to whoever can provide assistance.

Take care.