Pivot Table question...

[Banditeb]

I have a table with Months across the columns and warehouse and items down the rows. I am trying to automate an upload file and need it in a format with warehouse, item, Month and quantity...is there a way to do that with a pivot table? See simplified example below...

Table looks like this

Jan Feb Mar
Warehouse 1 Item 1 2 3 5
Warehouse 2 Item 2 8 6 2


Need This for Upload

Warehouse 1 Item 1 Jan 2
Warehouse 2 Item 2 Jan 8
Warehouse 1 Item1 Feb 3
Warehouse 2 Item 2 Feb 6
Warehouse 1 Item 1 Mar 5
Warehouse 2 Item 2 Mar 2

 

[SpillerBD]

You don't have a proper Data Table. The Date field, Month, is going across the sheet.
What you are looking for is an UN-Pivot transformation.
There are a number of methods, manual, macro and using Get and Transform.
Search: "UNPIVOT MACRO"
Unpivot using the Pivot Table Wizard: https://www.youtube.com/watch?v=xmqTN0X-AgY
Unpivot with Get and Transform: https://www.youtube.com/watch?v=JfuFGMfgvfY