Checking for values across multiple columns

Checkered Past

I am trying to write a formula that checks for blanks across 4 columns until it finds a value. I have researched this much and have written countless formulas with no luck. Can someone help me out here? Below is what I am trying to achieve.

KPH

Is the formula you are looking for the one to populate the Handling Agent column? If so, is there a possibility that two group columns could have a value in. If so, how would you like that to display?

If you only have one name per row, I think a simple JOIN could do what you want.

KPH

Is the formula you are looking for the one to populate the Handling Agent column? If so, is there a possibility that two group columns could have a value in. If so, how would you like that to display?

If you only have one name per row, I think a simple JOIN could do what you want.

Checkered Past

Thank you so much! I was making this way harder than need be!

KPH

Sometimes it is better to stop thinking 😀

Glad I could help.