Concatenate if values exist and add header

  • Hello,

    I have a spreadsheet with 10 columns, Year 1 - Year 10.

    I am trying to combine a row of values all into one cell, and have it say "Y1 $x.xx, Y2 $x.xx, Y3 $x.xx" etc.
    I was thinking of something like IF a value exists, add a "Y1 $value" and concatenate with the next year if applicable, but not sure how to start it.
    There are a lot of rows that do not have the full values for 10 years, so doing it the old & & way didn't work.

    Any help would be appreciated, thanks.
    Spreadsheet is attached.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!