Turn one row into multiple rows in excel

I have items that are available in multiple Distribution Centers. Currently I have them in columns with each distribution center as a different column and each item that is available is marked with that distribution centers code.

Current sheet:

DC in multiple columns.JPG

There is currently one row per item. The distribution centers are on the right side of the sheet. There is not a column heading for each one. A column is dedicated to each distribution center and its abbreviation is entered on rows where it is applicable. An item with multiple distribution centers will have multiple distribution center codes.

I need to have a single distribution center column, with a single distribution code per row, and then duplicate the rows as needed for items that currently contain multiple codes.

What I want to do:

DC in multiple rows.JPGSample Sheet.xlsx

The only way I can think of doing this which would be time consuming would be to copy the item number into multiple rows and in the column that has the distribution code I would change code for the item that is available in each distribution center. I will be doing this for 900 items. Is there an add on or an easier way to do this?