Merging columns to remove nulls and create one complete list

[jamieeee]

Hi 

I am trying to merge / combine columns A , B and C so that if the name is '[Null]' in Column A ("Player"), the name is filled with the data from column B or C.

I have been playing around with various joins / unions for a while but have had no luck. Similarly, all previous discussions on this topic have not proved fruitful. 

The screenshot below is taken from my workflow after using a Join.

Any help is greatly appreciated!

Thanks

[bhrmitra · Accepted solution]

Hi jamieeee,

This can be solved using a formula tool.

Workflow:-

Output:-

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Thanks,

Abhra Mitra

[RobertOdera]

Hi, @jamieeee 

Please mark as an acceptable solution, and Like, if this works for you.

Please note that I'm using IsEmpty versus IsNull because IsEmpty is more robust (it evaluates for both nulls and blanks :)).

Solution. create new ColD

Solution. Update ColA

Workflow

[jamieeee]

Thank you!