Multiple Columns which need to be combined with some columns not having all the cells fill

hmmm

i tried to avoid the nested if's too, but ended up with this insted

Please Login or Register  to view this content.

what it's doing is putting a comma in-between each value, but then using the replace function to remove double commas, then if what's left ends with a comma it removes the final comma

if i think of a simpler alternative method i'll let you know

@ThirtyTwo

Wow......That did the trick....Wasn't even close to the abomination that I created. I'm going to go and flush mine down the toilet and just use yours! Thank you.

I did have to add a couple of &"," in between a couple because it missed one in between two particular cells so I''l repost it with the fix so someone else can use it:

Please Login or Register  to view this content.

glad to have helped, but like you, i wasn't expecting a formula for the solution to be so long or look so messy, but it works, and that's the main thing, it provided a fix for what you needed