- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 02, 2022 07:51 AM
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 05, 2022 07:52 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 05, 2022 08:17 PM
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
```
```
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 06, 2022 06:24 AM
It works😍!! Thank you very much!! I really appreciated it! 😀

- « Previous
-
- 1
- 2
- Next »