Need Help. Multi Field and Multi Row

[smile_dt06]

I am new to Alteryx and would like to seek your help. I have a data like this and I would like to use alteryx to auto fill in the blank columns as highlighted in yellow. Please help. Thank you so much for your help.

[atcodedog05]

Hi @smile_dt06 

Is there any logic on how its been filled up and places where its not filled?

[smile_dt06]

Hi @atcodedog05 the logic is as follows:

- Row 1: start with cell contains "income", if the cell next to income is null() then fill with "income" until it reach cell contains "deduction", same logic apply for "deduction" until it reach cell "payment" then stop. Note that the number of "income" and deduction can change because the user may add new columns within these two groups.

- Row 2: same logic, start with cell contains "benefits in kind", if next cell is null() then fill with "benefits in kind" until it reach cell contains "total income" then stop.

- Row 3 no change.

However, the relation between the rows must be kept. Similar to this.

Please help. Thank you.

[smile_dt06 · Accepted solution]

Hi @atcodedog05

actually I can solve this problem by attached workflow. However, if you have better solution, please share with me. Thank you.