case statement - Combining three columns of text data in Google Data Studio

Question

I have a table of data like so.

Comment 1	Comment 2	Comment 3
This is a text comment	null	null
null	this text comment has a number 2	null
null	null	this is comment 3

question from:https://stackoverflow.com/questions/65907179/combining-three-columns-of-text-data-in-google-data-studio

Answer 1

Create a new calculated field, with a nested function? The below worked on your example:

REPLACE(CONCAT(CONCAT(Comment1,Comment2),Comment3),'null','')