Change the formulas in columns DM to DP to this:
DM5:
=SUBSTITUTE(TRIM(CONCATENATE(BS5&" "&BW5&" "&CA5&" "&CE5&" "&CI5&" "&CM5&" "&CQ5&" "&CU5))," ",",")
DN5:
=SUBSTITUTE(TRIM(CONCATENATE(BT5&" "&BX5&" "&CB5&" "&CF5&" "&CJ5&" "&CN5&" "&CR5&" "&CV5))," ",",")
DO5:
=SUBSTITUTE(TRIM(CONCATENATE(BU5&" "&BY5&" "&CC5&" "&CG5&" "&CK5&" "&CO5&" "&CS5&" "&CW5))," ",",")
DP5:
=SUBSTITUTE(TRIM(CONCATENATE(BV5&" "&BZ5&" "&CD5&" "&CH5&" "&CL5&" "&CP5&" "&CT5&" "&CX5))," ",",")
and similarly with the formulas in columns BN:BQ, then your formulas in DS and DT will work as they are.
TRIM removes any leading and trailing spaces, and replaces any consecutive spaces within the text with a single space. SUBSTITUTE then replaces those single spaces with commas.
|