DATA OUT OF THE PIVOT TABLE PLEASEEE!!!
Does anybody knows how to get the data out of the pivots table?
I meant all the data in rows again but group in the NEW format. THANKS!!! |
DATA OUT OF THE PIVOT TABLE PLEASEEE!!!
Hernan
If you EditCopy the pivot table and then EditPaste special...Values to a new location Is that what you are looking for? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "HERNAN" wrote in message ... Does anybody knows how to get the data out of the pivots table? I meant all the data in rows again but group in the NEW format. THANKS!!! |
DATA OUT OF THE PIVOT TABLE PLEASEEE!!!
no thank you anyway, I want the source information in rows again instead of
Pivots only that this time sorted as I sort the pivot. "Nick Hodge" wrote: Hernan If you EditCopy the pivot table and then EditPaste special...Values to a new location Is that what you are looking for? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "HERNAN" wrote in message ... Does anybody knows how to get the data out of the pivots table? I meant all the data in rows again but group in the NEW format. THANKS!!! |
DATA OUT OF THE PIVOT TABLE PLEASEEE!!!
Hernan
If you can simply add one value field, no column or row fields, so effectively you have a header and one data cell, double-clicking this data cell will explode the underlying data onto a new sheet...does that help? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "HERNAN" wrote in message ... no thank you anyway, I want the source information in rows again instead of Pivots only that this time sorted as I sort the pivot. "Nick Hodge" wrote: Hernan If you EditCopy the pivot table and then EditPaste special...Values to a new location Is that what you are looking for? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "HERNAN" wrote in message ... Does anybody knows how to get the data out of the pivots table? I meant all the data in rows again but group in the NEW format. THANKS!!! |
All times are GMT +1. The time now is 09:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com