PIvot table creation - Removal of Cell data before creation

[waseem-akram.shaikh]

Hello team i need to create a pivot table -
Step 1 : Excel contains some false and true data ----> I need to remove the false data before i create a pivot chart
I tried replacing the ‘false’ with space , but when i create a pivot of that - it consider the space as 1 value and provides incorrect information while creating the pivot table.

e.g: excel has following data

NAME COL1 COL2 COL3 COL4
XYZ FALSE FALSE TRUE TRUE
ABC FALSE FALSE TRUE FALSE
WSA TRUE FALSE FALSE TRUE

OUTPUT :

NAME COL1 COL2 COL3 COL4
XYZ TRUE TRUE
ABC TRUE
WSA TRUE TRUE

Create a pivot only for true values