Duplicating Column (+ special condition)

Hello,

I would like to duplicate a column, but for the new column to start from the second entry (so well, not entirely a clone of the first one).

Example:

Names Names (new column)

John Claudia

Claudia Walter

Walter Mitch

Mitch (Null)

Thanks!

Developer

Accepted answers

You can use Multi-row formula tool like below.

Workflow:

Hope this helps : )

You can use Multi-row formula tool like below.

Workflow:

Hope this helps : )

Super helpful, thank you! Have a great day! 😊

Actually @atcodedog05, wanted to ask what would be the approach if we had to repeat the action multiple times, ie

Names Names (new column) Names (new column1) Names (new column2)

John Claudia Walter Mitch

Claudia Walter Mitch (Null)

Walter Mitch (Null)

Mitch (Null)

Thanks a lot!

Here is how you can do it.

Workflow:

Hope this helps : )