I have information in an Excel spreadsheet in the format of a simple pivot table (it is not actually a pivot table, but the info looks similar to the output you’d get from a pivot table). I need the information in a “list” to be able to import it into a database (similar to what you’d have when starting out & wanting to manipulate the information using a pivot table). Example: Monthly Forecast, with Part Number on the left, and the months across the page, with forecast quantities for every month. Required result: Multiple rows with : Part Number, Month, Quantity.
