Assistance with If Then Else

[LauraJackson]

Hi everyone,

I am fairly new to Excel formulas and could use your help.  Here is an example of my data I am working with:

Owner 1	Owner 2	Owner 3	Owner 4	Owner 5	Owner 6	Owner 7
Lawrence
					Shari
		Bernard
			Kristen
						Gustavo
	Brooke
				Maitane

I would like to add a column H that formulates the Owner by checking for a value in A, B, C, D, E, F or G. It would look like this:

Owner 1	Owner 2	Owner 3	Owner 4	Owner 5	Owner 6	Owner 7	Account Owner
Lawrence							Lawrence
					Shari		Shari
		Bernard					Bernard
			Kristen				Kristen
						Gustavo	Gustavo
	Brooke						Brooke
				Maitane			Maitane

There is only ever one name in each row (record).

Any thoughts on what this formula would look like?

If A2 has a value, populate that value. If it is blank, populate with the value in B2. If B2 is blank, populate with what is in C2, and so on.

Thanks!

[#2 · Accepted solution]

@LauraJackson 

In H2:

=CONCAT(A2:G2)

Fill down.

[#3]

Amazing, thank you! I was overthinking it