I have a table that was formated poorly for data analysis. I need the data to be in columns. Does any one know how to re-arrange the data with out doing it manually?

Current State.xlsWant.PNG


There is currently a column for defect mode and item (defect discription two) and then their is a row of dates and across from each column and under the appropriate date there is a qty. I need there to be a date, corresponding defect mode and item, and the qty for that date to be in a row.

Any ideas? Other wise I am sorting through it all manually.

Thanks