Adding new column based on another

Hello,

I am trying to add a new column to my dataset that is based on the following row in the dataset. I have attached an example of the input data I’m working with and the desired output data for this example.

I have a series of ‘from’ data that is listed in a sequence based on record numbers. I want to add a new column called ‘to’ that takes the ‘from’ ID from the following record in the sequence and adds it to the preceeding row.

Any help would be really appreciated.

Thanks!

Example Sequence Link.knwf