Hi, I have items that are only 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. I need to have one column, then have one distribution code in the column. 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. Below is an small sample of what I want to do. I will be doing this for 900 items.