# Re: Concatenate Problem

Solved
Jump to Solution
2752 0
cancel
Showing results for
Search instead for
Did you mean:
8 - Airtable Astronomer

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!

12 Replies 12
8 - Airtable Astronomer

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

18 - Pluto

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})
)
)
```
8 - Airtable Astronomer

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