Concatenate columns with delimiter, some columns blank

[JWorthy]

Hello,

I ran a suvery on user ethnicity.

I'm trying to create a new column from a concatenate of 12 columns

Many of the columns have blank as they only have a value when the respondent checked that ethnicity box. A row can have multiple columns containing values as the respondent might be White - English - Londoner.

I want to put in a delimiter between each concatenated value i.e

Column1 & ", " & Column 2 & ", " & Column 3 & ", " & Column 4 & ", " & Column 5  & ", " & Column 6

What I want would look like:

White, English, Londoner

but don't want the end result to look like the below because columns 2 to 4 were blank:

White, , , , English, Londoner

How do I do this?

Thanks!

[Floriankx · Accepted solution]

If you are doing it in DAX you could add a IF(ISEMPTY(column n);", "&column n;BLANK() before every column, but the formula is getting huge.