Pivot table - Excel list or database + multiple consolidations ranges

P

philwongnz

Hi guys,

Just wondering whether this is possible. I would like to pivot a group
of data in which for example it has cost centres in column "A" then
Projects in column "B". Column C onwards consisted of each months. The
question is can I pivot the data in which it will first be by Cost
Centres then projects, then months by each column?

I know I can achieve having the months in each column by using the
multiple consolidations ranges in the pivot wizard, but after the data
has been pivoted, it doesn't allow be to separate the cost centres and
projects like I can do in the excel list or database format.

Thanks
 
Top