How to fill in nulls w/data from row below-Same Data but different values in two fields

[blitz45]

Hi There!

Below is a screenshot of my workflow. The second screen shot is what I am trying to achieve but have failed to do so. Please help? 

How do I get the values from "NAME NO" filled in to the nulls and same with "NAME YES". 

I am trying to consolidate the rows because all of the data are the same and I am trying to have just one row by filling in the nulls with the value below. 

  

Thank You,

[bpatel · Accepted solution]

hi @blitz45 ,

You can use the multi-row formula to fill in values like this 

hope this helps!

[vizAlter · Accepted solution]

Hi @blitz45 — Try this solution... solved through "Tile" and Cross Tab" tool:

Please mark it "Solved" or "Solved" with a Like if it resolved your query. This will help other users find the same answer/resolution.  Thank you.

[grazitti_sapna]

Hi @blitz45 , try this if it works for you.

Thanks.