Does anyone know a function, or a set of functions that would make the data look in such way?

Copper Contributor

There needs to be a text inserted in all the columns in front of the first value that is above 0 and also some text after the last value that is above 0.

The values in between the values that are >0 need to be 0.  

 

The data would then look like this. (this was manually edited)Forum.png

1 Reply