Hi,
I have one column where I need to shift only that column to one cell down.
Input
Output
Sorry Input is below
This is my try, please check..
I have tried this one. This is moving the data one cell down but it is keeping the original data as it is. Can we have anything to move data one cell down with out keeping the original data as it is.
Hi @SureshBurra1982 ,
You can do than by offsetting that original C2 column by one cell, essentially pushing everything a place downwards.
I used the generate rows tool to generate that single null cell and then unioned it at the top of the Old C2 column. Then bringing back the two streams, I decided to Join on record position to achieve the desired format.
Let me know if that works for you.
Cheers,
Angelos
I have multiple columns in my case, just for example I just provided one random column for info, do we have any way that we can handle with in the Multi Row Formula?
I guess so @SureshBurra1982 ,
My concerns with the formula tool is that probably you are going to need one for each column you want to offset, so it's not very flexible in the things it can achieve.
Give this another try, I have included another column in the input just to test what would happen in your case
and changed the union tool to keep all fields. Then the output looks ok: