Concat column header + value in cell across a table if no blanks

[testarossa93]

Hi,

I'm trying to concat non-zero values across a table using the header of the column. I would like my results to show as column F, which formulas should I look at to make this work?



Thanks

[Rick Rothstein]

How many columns with headers does your real worksheet have?

What version of Excel are you using?

[testarossa93]

How many columns with headers does your real worksheet have?

What version of Excel are you using?

I'm using Excel 2016 and I have 14 columns with headers.