Create a comma separated list from sometimes empty columns

[Krivo]

I think it is a simple question - maybe you can help me out.

I need to create a comma separated list (to be used in an url)
Some of the values might be present - some might be empty

Example
A_1,B_1,C1

Sometimes the value C1 is not present and therefore the result should be
A_1,B_1

If the values are present all the time it would be easy to use a template column - but it might vary which values wound be there.

Other examples
A_1
A_1,C1

I thought I would be able to use array column or join list column - but cannot see a way through that.

Any thoughts on that?

[Darren_Murphy]

Use a Make Array column to first create an array, then use a Joined List column on the array column.

This should get the result you want.

[Krivo]

@Darren_Murphy I thought I could do so - but the Joined List column isn’t available to choose for some reason.

Any suggestion what to do then?

[Jeff_Hager]

[Krivo]

@Jeff_Hager Thx - I will make an appointment with the optician

[Jeff_Hager]

Hehe, that part can be easily missed sometimes.