Linking Data between columns

Hello, is it possible to add a new column with data from other columns?

Like this:

Column 1: Name
Column 2: Phone
Colum 3: Email

Colum 4 (formatted):

{Name}
{Phone}
{Email}

Thanks in advance.

Easy! Use a formula to concatenate the content from other columns. The formula is as simple as this: {Name}&" “&{Phone}&” "&{Email}

Thank you. Is it also possible to add characters that force a new line? I want the values to be in separate lines.

Formula columns do not support line breaks. Only long text columns do.

Then you need a script that copies values from the source columns in the long text column.

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.