Concatenate Problem

[Sara]

Hi everyone! I hope you had an amazing Thanksgiving!

I have some problems with my formula, I'm trying to concatenate two columns (see attachment ). As you can see, the Calculation column missed the "commas" of the originals columns, and moreover, if there is anything in a column, it adds a comma.

I would like that my calculation is :

1 Report Name	2- Report Name	Calculation
D, E	C, F	D, E, C, F
F, C		F, C
	D, E	D, E

my formula is in the attachment.

What am I doing wrong?

Thank you very much!

[Sara]

Base I created a "fake" base, so you can try it if you want. Thank you very much!

[TheTimeSavingCo · Accepted solution]

Hi Sara! Thank you very much for creating the base for me!

I added kuovonne's original solution about the `ARRAYJOIN()` to the formula and I think it should be what you're looking for

```

IF(

AND(

ARRAYJOIN({1- Report Name}),

ARRAYJOIN({2- Report Name})

),

ARRAYJOIN({1- Report Name}) & "," & ARRAYJOIN({2- Report Name}),

IF(

ARRAYJOIN({1- Report Name}),

ARRAYJOIN({1- Report Name}),

ARRAYJOIN({2- Report Name})

)

)
```

[Sara]

It works😍!! Thank you very much!! I really appreciated it! 😀