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! 

JoeS

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.

Continuing Data.yxmd