| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Data Source external excel file | Excel Discussion (Misc queries) | |||
| Count only if another column has data in Pivot Table? | Excel Worksheet Functions | |||
| Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
Linear Mode
