TEXTJOIN if empty "" if not empty CONCATENATE the first cell in row with this cell

Hello

I am having trouble to come up with the right formula for the following problem.

I have to TEXTJOIN the content of all cells in a row.

• If the cells are empty then I want nothing to happen,
• if the cell isn't empty then need to concatenate the first cell in every row (column title) with the value in the cells, seperated by a ": ". Then separate with a "," and move on to the next cell

This is what i'm trying to get:
Screenshot 2021-05-25 at 19.56.29.png

The obvious solution would be to use

Please Login or Register  to view this content.

In my test file (see screenshot above) I have first used the following CONCATENATE formula and it gives me the correct solution:

Please Login or Register  to view this content.

The problem is that there are way too many columns (about 200) and it is not possible to use an array with CONCATENATE

So I'm forced to use TEXTJOIN istead!

I've finally come up with this formula, but sadly it does not work.

Please Login or Register  to view this content.

It just end up with a #NAME?

Does someone have a solution for this? It would be greatly appreciated, because it is super important that I manage to get this done somehow.

Best,
M

Correction: it worked perfectly