H
Hans
I have 4 columns with names, in some rows are none to 4 names. The names
appear random in any of the columns. It could look like this:
name1 name2
name3
name 4 name5
I want to get the first name that appears (from left to right) and put it in
the fifth column, like this:
name1
name3
name4
I can't figure it out, any help is welcome
appear random in any of the columns. It could look like this:
name1 name2
name3
name 4 name5
I want to get the first name that appears (from left to right) and put it in
the fifth column, like this:
name1
name3
name4
I can't figure it out, any help is welcome