Forum Discussion

Steve_comap's avatar
Steve_comap
Copper Contributor
Mar 06, 2020

Removing a pivot table yet keeping the data?

I pulled data from CRM, then wanted to add a couple of columns. Not the 2 new columns are not part of the pivot table. I don't need the pivot table anymore. How do i remove the pivot table function y...
excel
Pradeep_s_thachapully's avatar
Pradeep_s_thachapully
Copper Contributor
Mar 06, 2020
Hi_Steve_comap
Copy the whole pivot table and go paste special and choose value. It will remove your pivot table.
Thanks
Pradeep
  • Pradeep_s_thachapully's avatar
    Pradeep_s_thachapully
    Copper Contributor
    Mar 06, 2020
    You have to do it before you set the formula and than insert that two columns and set the formula
    Thanks
    Pradeep

Resources