How to re-order the columns and rows in a pivot table - Excel 2010

[Mirisage]

Hi Excel Forum,

I have created a pivot table using Excel 2010 (pl see "Have" table in the attached).


Question:
I need to re-arrange the order of columns and rows like shown in table called "wanted" in the attached.

Note: This is not switching columns and rows but re-ordering columns separately. And re-ordering rows separately.



My Approach:
I have copied the pivot table into a separate new excel sheet and done the re-ordering manually. But I have 10 pivot tables each having 10 columns and 10 rows. So, my primitive approach is very tedious.

Is there any elegant way?
Thanks

Mirisage

[Andy Pope]

You need to define a Custom Sort list and use that on the data.

http://www.contextures.com/excel-piv...e-sorting.html

[Mirisage]

Hi Andy,
Thank you very much.

Regards

Mirisage
p.s. sorry you may get multiple postings.