I've created a Pvt Table which contains 6 fixed columns and it will show data
depends on how many columns I wanted to see. In addition, I've created
another set of columns to copy data shown on the pvt table. So here is my
question, is there a way to activate cells with data on the Pvt Table?

Here is an example:
If I wanted to see 4 columns of data on the Pvt Table:
               Column A   Column B    Column C   Column D   Column E  
Column F
Row1           $27           $30             $49           Total

My other Set of columns should appear like this:
               Column G    Column H    Column I    Column J    Column K  
Column L
Row1            $27           $30             $49            Total

I'm trying to insert a function, if a cell contains data, activate that
cell, if it's a blank cell, dont show anything. I've tried =IF(A1="",+A1,0)
but my function does not seem to work and I don't know the command for
deactivate a cell (if there is any)

so help is much appreciated.

Joe