Hey everyone,

I'm making a concatenation formula that concatenates cells with a ", " (comma space) in between. I have twenty columns that it can concatenate from, but not all are filled. There are no blanks in between, for example:

Apple Orange Banana Grape Apple, Orange, Banana, Grape
Banana Grape Banana, Grape
Apple Grape Orange Apple, Grape, Orange
Apple Apple
Apple Orange Grape Strawberry Watermelon Cherry Lemon Apple, Orange, Grape, Strawberry, Watermelon, Cherry, Lemon

The final column in this table shows how I WANT my cell to display.

The formula I have so far works, but it is EXTREMELY cumbersome:

=IF(A2="","",IF(J2<>"",E2&", "&F2&", "&G2&", "&H2&", "&I2&", "&J2,IF(I2<>"",E2&", "&F2&", "&G2&", "&H2&", "&I2,IF(H2<>"",E2&", "&F2&", "&G2&", "&H2,IF(G2<>"",E2&", "&F2&", "&G2,IF(F2<>"",E2&", "&F2,IF(E2<>"",E2,"")))))))

And this is only for the first 6 cells, I need it to go out to 20. The important thing is that I don't want 15 random commas ,,,,,,,,,,,,,,,, at the end of my list in the cell, my current formula does this, but it's huge and hard to work with.

Is there a shortcut for this that I'm missing?