How to fill down and/or fill up in multiple columns?

[HW1]

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.

[HW1]

I tried this however, this one goes one way only (Fill Down).

There might be better ways to do it.

(If there are better solutions, I'll accept them as an answer else, this can do)

[Qiu · Accepted solution]

@HW1 
I think you are almost getting there.
Just modified a bit about the Sorting.

[Ben_H]

Hi @HW1,

I'm not quite sure I follow what you're aiming for but I've had a go based on your example.

Regards,

Ben