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

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...