Help

Mina2021

Hello,

I have data set with some null values where there is no action for each code and objective is to shift the null values in the front. where there is null action, that needs to be in the action 1. Need to make it dynamic.

Kindly help me to solve!

Thanks in advance.

Sample.xlsx

Workflow

Accepted answers

Qiu

@Mina2021
I hope it will work in your really business flow given the naming convention for columns will follow 'Action' and 'Diff'.

20210323-Mina2021.yxmd

Mina2021

Hi Qiu,

It's working perfectly.

Thank you for your support!

All comments

AngelosPachis

Hi @Mina2021 ,

So once you've shifted all the null values under action_1, what do you want to replace those values under actions 4 and 5?

Can you provide a sample of the output you're after?

Thanks,

Angelos

Mina2021

Hi AngelosPachis,

I have attached the format in the Backward tab of the file.

example:

1. Forward (only one null action)-

Backward should be-

If there is no null action then, will remain the same as Forward view:

2.Forward ( no null action) -

Backward should be as it is -

3. Forward -

Backward should be-

If you could help me, would be great!

P.S - Sorry I have attached wrong file.

Sample.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703