| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Pivot table back to Data Table
I have a Pivot table but i don't have the data source used to create it, i
want to convert it back to a normal data table. how can i do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert Pivot table back to Data Table
Double clicking on any cell of the pivot table will give you the underlying
data adding up to that cell. in case you want the entire data just go to the grand total cell of the pivot and double click the same. it will open up another sheet and list out the entire data. Trust this works for you. Regards, Manoj "Samaa" wrote: I have a Pivot table but i don't have the data source used to create it, i want to convert it back to a normal data table. how can i do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert Pivot table back to Data Table
It did, Thank you very much
"Manoj" wrote: Double clicking on any cell of the pivot table will give you the underlying data adding up to that cell. in case you want the entire data just go to the grand total cell of the pivot and double click the same. it will open up another sheet and list out the entire data. Trust this works for you. Regards, Manoj "Samaa" wrote: I have a Pivot table but i don't have the data source used to create it, i want to convert it back to a normal data table. how can i do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table: hyperlink back to source data | Excel Discussion (Misc queries) | |||
| Convert Pivot Table to Normal Data table | Excel Discussion (Misc queries) | |||
| Vlookups in a Pivot table brining back OFFSET Data | Excel Worksheet Functions | |||
| Transforming pivot table back to the source table | Excel Worksheet Functions | |||
| Pivot Table - How Do I Convert Data? | Excel Worksheet Functions | |||
Hybrid Mode
