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
Solved! Go to 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
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
Thank you!