Pivot Table - Cols to Rows?

[treva31]

I have a pivot table in Access that is based on a query that looks like this:

Project Material1 Material2 Material3
1 223 331 423
2 423 234 244
3 855 773 343

I want the materials to go from the columns into the rows of the pivot table so they can be collapsed and expanded and have a total at the bottom. And so its just one column per month displayed.
Like this:

Project Material Amount
1
Material1 223
Material2 331
Material3 423
2
Material1 423
Material2 234
Material3 244

I think I need the pivot table to be based on a query that has a separate row for each material value? But I dont know how to make that out of the existing a single table.

Please see attached file.

 

[Uncle Gizmo]

Is your base table constructed in this manner?

Project Material1 Material2 Material3
1 223 331 423
2 423 234 244
3 855 773 343

 

[treva31]

Is your base table constructed in this manner?

Project Material1 Material2 Material3
1 223 331 423
2 423 234 244
3 855 773 343

Yes.
I know it would have been better to have a separate meterials table, but this is what I have.