How to fill in fields above/below and leave last row empty after the last row with value?

[mrichman]

Hi All, 

I am trying to create a workflow where I ideally get table B but currently getting A. Hope you guys could help me out. 

Table A:                                             Table B: 

[echuong1]

Can you expand upon your logic and explain how you want the NAAA to be filled in? There doesn't seem to be a pattern.

[mrichman]

Hi enchoung1, - NAAA is just to say this filled is 'not applicable' but should be filled with something.

[wdavis]

Hi @mrichman 

I have added a sample workflow which uses a Multi-Row Formula to allow you to fill in fields above and below the existing data set.

- You can build IF statements which reference rows above and below

- Use the IsEmpty or IsNull formulas to identify rows in your data you want to apply logic to

As @echuong1 mentioned, if you are able to provide us with the logic for when a field is not applicable, it might make it easier to help here.

Let me know if the workflow is what you are looking to do, or if you need any further assistance!

Thanks

Will

[mrichman]

hi, thanks for the example and assistance. I saw the alteryx file/result however row 14 and 15 should not be filled. 😞 

[grazitti_sapna · Accepted solution]

Hi @mrichman , try using this workflow. I hope this helps.

Thanks.

[mrichman]

Awesome - it's working!