How do i rotate a pivot table?

collinsc

Board Regular
Joined
Sep 13, 2006
Messages
240
I hope this is an easy one?
I have a pivot table with projects across the columns and months down the rows. i need to chane it so that the projects are rows and the months are columns.
Is there an easy way to rotate it 90 degrees?

i though i could just drag the row field to column field and vice versa- but it takes some of the formatting off... i.e. if i drag it the date data goes in row format instead of column format.!

thanks
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Are you sure you're dragging it to the correct segment? Try doing it in the wizard; right-click pivot table -> wizard -> layout.

Regards,
Jon :)
 
Upvote 0
i am able to get the data on the pivot table- just not the way i want it...!
i want it like this:
APR MAY JUN JUL AUG......................
001 004 002 003 009.........................
001 002 005 004 008...........................

If you know what i mean?
i reckon its something to do with COUNT or SUM?
 
Upvote 0
Hmmm could you post a sample of the source data? Preferably with Colo's HTML maker...
 
Upvote 0
I am at work so unfortunatley cannot dl the HTML maker. I will attempt to type an example...

DATA PRJ: A12345 B12345 C12345 D12345
Count of Sep 06 06 09 04 08
Count of Oct 06 04 10 07 02
Count of Dec 06 08 07 02 06

Hope this gives you some idea?
i want it to read like...
PRJ DATA: Sep 06 Oct 06 Nov 06 Dec 06
A12345 06 09 04 08
B12345 04 10 07 02
C12345 08 07 02 06
 
Upvote 0
Hi

If you right-click on the Data descriptor, navigate to Order and you should see an option to "Move to Column".

Richard
 
Upvote 0
Ok- i now have a follow up questions!
it says "count of sep 06" can i rename it so it says "sep 06" ???
i cant do it within the pivot table... is there a renaming area?
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,287
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top