How to unpivot the pivot table in excel

[Raju Chacha]

Recently I was trying to make the unpivot the pivot excel sheet, but however I was fail to do it, I even have try many steps to unpivot but still not able to do that thing in excel. I have visited several forums to get the solution but still I have not get the proper solution for this conversion of pivot table in to unpivot table in Excel, so if you guys have any of the information or any of the solution then please let me know.

[BillieJ]

According to my suggestion if this is based on a range/table in a worksheet? Then Find the grand total cell and then double click on it. You'll see the data--but it won't be formatted pretty.

[Alfons]

I have not try this out but however it may be worked for you, so for that you just try to Select the entire area that you want to unpivot, after that go to Edit and then select the option Goto. And from there go to Special/Blanks and then do = uparrow Ctrl-Enter. May be this you will able to unpivot the Table in Excel.