I have a access table that was created from an import of a Excel spreadsheet. All the Dates 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
Item number | Usage Date | Qty
010019 | August 2017 | 34
010019 |September 2017 | 10
010019 |October 2017 | 57
No need to include the zero quantities so the result table will be simpler.
Attached is a copy of the database with this table. Keep in mind that the way to UNPIVOT should be dynamic. Each month we import a new spreadsheet and the column names will be different, so we need to UNPIVOT after each import of the spreadsheet.