Hi Saturn,

I would suggest you to do little research on below options:-

One is two use GetPivotData function....

Another is two use formula like... =IF(isblank(e4),"",e4)...

If you face any issues, post the sample file with pivot. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>