Comma Delim to Rows - Everything Else Copied

Hey Guys/Girls,

I'm a first time poster, so please bear with me if I am not 100% spot on with my question.

I have a spreadsheet of data that contains multiple item numbers (one per row) and one column in that list 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 Product Code, 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 O 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. In the current example, Row 2 would not change, then Row 3 would be Item 1234 and Product CodeAB along with everything else in the current row copied to that row. Then, Row 4 would be Item 1234 and Product Code AC with everything else in the current row copied to that row.

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....but it's not 100% required.

Thanks so much to whoever can provide assistance.

Take care.