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
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