Pivot Table With Multiple Columns

[ryckiej]

How do I create a pivot table with multiple data columns? My fixed asset software will not let me create a report to list multiple months/ quarters. I've created a spreadsheet that I can dump each month into, but I'd like to be able to sort by G/L acct or Department. When I try to create a pivot table, I can't get it to accept each month as a data field. Ive attached a copy of the spreadsheet that I'm using & the report that I'd like it to look like.

[royUK]

I don't think that your source data is laid out to do this. If I undestand you, you need the months in one column.

[Dave Hawley]

ryckiej, please don't use meaningless abbreviations in Thread Titles.

[ryckiej]

My apologies Dave, I didn't realize that mult. (for multiple) was a meaningless abbreviation

[Dave Hawley]

Sorry, I meant any abbreviations.