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 yet keep the data?

I can copy, paste special text only. But then I loose my formulas. 

Any ideas?

Thanks

excel

2 Replies

Sort By
  • 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