Getting not NULL values from three columns in one column in QGIS

Question

As you can see, I have three columns with the important features for me (a, b, c, d, e, f) - no matter of size. I want to copy them into new column "name". The problem is when I try to copy with case, or if, or anything else it doesn't work. For example:

If I want to copy "name1" to "name", I will get 'a', 'b' and NULL, then after that I try to copy "name 2" I get 'c' and 'd', but also NULL at the place where it should be 'a' and 'b'.

Answer 1

Use this expression that utilizes the concat() function:

concat("name1", "name2", "name3")

Answer 2

Another solution (as was mentioned by @Vince) is to use the coalesce() function, like:

coalesce("test1", "test2")