I have a access table that was created from an import of a Excel spreadsheet. All the DueDates for the part are represented as column names. I need to essentially "UNPIVOT" this table and put the column names as rows. The desired output would look like this
ItemNumber |DueDate | Qty
A |07-11-16 |1
A | 07-18-16 | 1
Attached is a copy of the database with this table. Keep in mind that the way to UNPIVOT should be dynamic. Each week we import a new spreadsheet and the column names will be different, so we need to UNPIVOT after each import of the spreadsheet.