Forum Discussion

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

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

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