I have a table with 25 columns and 2000+ records. Columns 2 through 25 are different values for the first column. I need to keep column 1 as column 1, but make columns 2-25 as column 2 Row 1, Column 2 Row 2, Column 2 Row 3, etc. and then start with the next record once Column 26 is reached. I may have blank cells in the columns so I cannot stop the loop when the field is blank. I have attached a sample of what I am trying to accomplish and am hoping that someone can understand what I wrote.
Thank you for your help!
Original Data
Clothing Color1 Color2 Color3 Color4 Color5
Shirt Red Yellow Blue Green Orange
Pants Yellow Blue Green Orange Red
Hat Blue Green Orange Red Yellow
Scarf Green Orange Red Yellow Blue
I need it to look like this:
Clothing Color
Shirt Red
Shirt Yellow
Shirt Blue
Shirt Green
Shirt Orange
Pants Yellow
Pants Blue
Pants Green
Pants Orange
Pants Red
Bookmarks