I have a dashboard that looks like this:
And I'd like to clear all the values I circled in red (set them as blank).
The complicated part is:
- I have 243 columns
- Everything we're looking at now is on one row of the data, all of those red items are each from their own column on the row associated with me in February
- I'd only clear out the 0's if there was no PI/Cost center/short title/ or sponsor associated with them. (which are each in their own column)
Here's the same visual but with the column labels at each spot:
So for instance in this row (again the whole page is from one row), the columns pi_17, cc_17,st_17 are all blank, so I'd clear the zero's in eb_17, ep_17, and pe_17.
Here's that in a different view of the raw data:
Because there were values in the rows/columns circled in black, I'd leave those green ones alone. Because the red rows/columns are blank... i'd clear the blue areas. Does that make sense?
I'll take any solution, but ideally it's something I don't have to write a million times, given my 243 columns.