Duplicating Column (+ special condition)

[insomned]

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! 

[atcodedog05 · Accepted solution]

Hi @insomned 

You can use Multi-row formula tool like below.

Workflow:

Hope this helps : )

[insomned]

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

[atcodedog05]

Happy to help : ) @insomned 

Cheers and have a nice day!

[insomned]

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!

[atcodedog05]

Hi @insomned 

Here is how you can do it.

Workflow:

Hope this helps : )