I have 2 rows of column headers coming from an excel file
A few of these rows are null. I want the null in the first rows to be filled from below and the ones with nulls in the second rows to be filled from above.
I am trying transpose and then fill down but its not working perfectly.
I tried the multi row tool with the formula
IF [Name] = [Row+1:Name] // Checks if the row values match with the below
AND ISNULL([Row-1:Value]) // Checks if the row has nulls
THEN [Value] // Then fill down
ELSE NULL()
ENDIF
How can I do it?
Please find attached workflow example.
