How to combine/concatenate columns while ignoring nulls?

[Anonymous]

I would like to combine/concatenate all the columns (while ignoring the nulls). 

I've tried adding a custom column using:

[Number ID]&[Grouping 1]&[Grouping 2]&[Year]&[Quarter]

but it gives null as the result for each row. 

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,

Try selecting columns and merging them. The UI lets you select the delimiter. Not sure how it works with null. But you may be able to add an if statement to that..

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel