Found a few options using VBA but that's a realm I'm not familiar with. Is there a formula/function someone could recommend?
I found something like this...
=CONCATENATE(A1,IF(ROWS(A1)=COUNTBLANK(A1),A2, IF(ISBLANK(A2),"","," & A2)),IF(ROWS(A1:A2)=COUNTBLANK(A1:A2),A3, IF(ISBLANK(A3),"","," &...