Continuing Data

[JH123]

Hi everyone!

I wonder if anyone will be able to help me with the following. I have two columns of data and I am wanting the data in column 2 to start on the next row of column 1. 

Column1   Column2

  [null]             A

     B               C

     D               E

     F               G

And i'm wanting the output to be the following: 

Column1   Column2

    [null]          A

      A             B

      B            C

      C            D

      D            E

      E            F

      F            G

I'm not sure how to go about this, so any help or tips appreciated...Many thanks! 

[cmcclellan]

A multi-row formula tool, where Column1 = [Row-1]:[Column2]

[JoeS · Accepted solution]

Hi @JH123 

I have built a workflow out to achieve your output.

I created two streams, one for Column1 and one for Column2, then joined by record position to drop off the last part.

Let me know if you have any questions.

[JH123]

Many thanks @JoeS ! Worked perfectly 🙂