Concat columns, skipping blanks

I hope I’m not overlooking the obvious.

I’d like to use columns like name, address 1, address 2, address 3, city, state, and zip.

From that, I’d like to make a column with embedded newlines, formatted as a standard address.

Is this a job for JavaScript?

It would be easier with Substitute. See attached.

substiute.transform (1.8 KB)

1 Like

And to remove blank lines:

1 Like

Cool - many thanks!

There are many things like this that wouldn’t take long to implement with a short Python script, but Easy Data Transform is quick and allows for exploration.

Very nice tool!

1 Like