Filling blank column fields with precedent amount

[isilvera]

Hello Alteryx Community, I have this cohort analysis, which I need to be in this pivot way.

In the attached image, it shows how null spaces are affecting my analysis. What I expect is that for example:

Those blank spaces after the 5 would be populated with 5 and the ones after the 4 would be populated with 4 and so on.

Please help on this. I am attaching a picture of the workflow as well as the data is highly sensitive to share the wflow.

[MarqueeCrew · Accepted solution]

@isilvera ,

Glad to help this fine Friday.  Using a TRANSPOSE I can inspect the data in order.  I make the NULL updates and revert back to the original horizontal format using the CROSS TAB.

There are a few configurations to watch for.  Please open my workflow and see what is happening.

Cheers,

Mark

[isilvera]

Mark! such a lifesaver!!! Thank you

a lot of time was saved with this solution.

Regards,

Israel