Formula needed for If/then capturing Heading Title and Value

I am in need of help to write a formula to capture not only a result from a If/Then statement but also a corresponding value that triggered the If/Then result. For example, see the attachment to show what is needed. For column E, is there a formula that can produce the same result if the values in each column are greater than 0 respectively? Thank you!

You can use this in E2:

=SUBSTITUTE(IF(A2>0,LEFT(A$1,5)&A2&", ","")&IF(B2>0,LEFT(B$1,4)&B2&", ","")&IF(C2>0,LEFT(C$1,3)&C2&", ","")&IF(D2>0,LEFT(D$1,3)&D2&", ","")&",",", ,","")

I'm not sure if you wanted the same for column D - if not, then omit the part in red above.

Hope this helps.

Pete

Pete, thanks for that formula. I inserted it and I am getting the error message that "You've entered too few arguments for this function."

Any thoughts?

Thanks!

Josh

I've attached the file that I tested it on (although I put the formula in G2).

Hope this helps.

Pete

Thanks Pete, I really appreciate the help on this one...that worked!