Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News Editorials & Other Articles General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

Apple Users

Shermann

(8,770 posts)

4. Try this

Reply to tiredtoo (Original post)

Sun Apr 11, 2021, 03:43 PM

Apr 2021

=CONCATENATE(B2,IF(ISBLANK(B9), "", ", " ), B9,IF(ISBLANK(B16), "", ", " ), B16,IF(ISBLANK(B23), "", ", " ), B23)

It looks for blanks and adds the commas as necessary. The B2 row can't be blank but B9,B16,and B23 can be. You can extend the formula to the maximum number of columns possible and use the same formula for every row.

Edit history

Please sign in to view edit histories.

Recommendations

0 members have recommended this reply (displayed in chronological order):

7 replies

= new reply since forum marked as read

Highlight:

Changing values in formulas based on calculations [View all] tiredtoo Apr 2021 OP

If there is I would love to know WA-03 Democrat Apr 2021 #1

This message was self-deleted by its author padfun Apr 2021 #2

Yes. There should be a ROWS function. padfun Apr 2021 #3

Try this Shermann Apr 2021 #4

More... padfun Apr 2021 #5

OK, Shermanns answer is probably best for you padfun Apr 2021 #6

Thank you all for the advice but, tiredtoo Apr 2021 #7