How to fill null values across columns using previous value

[Paridhi_Agrawal]

Hi All,

I have a data set like below, where in row 1 some values are coming as null.

What I want is to fill those null with there previous values.

 Data Set

Expected Output

[Paridhi_Agrawal]

sample data attached

[DataNath]

Hey @Paridhi_Agrawal here's how I'd go about it. I've attached 2 methods as the top one uses functionality only available in the latest versions of Alteryx i.e. the Coalesce() function. The bottom is compatible with older versions:

[flying008]

Hi, @Paridhi_Agrawal 

FYI. (If you have the macro of Multi-Rows and Multi-Columns Formula.)