Forum Discussion
Solved
CONCAT question
Hi everyone, I need some assistance please with a concatenation. Here is an example of my data: Owner 1 Owner 2 Owner 3 Owner 4 Owner 5 Josue Josue Caitlyn ...
=IFERROR(INDEX(J2:P2,SMALL(IF(J2:P2<>"",COLUMN($A$1:$G$1)),1)),"")In my first reply unfortunately i didn't consider that the data is in columns J to P. The above formula returns the intended results in my sheet. The COLUMN part is COLUMN($A$1:$G$1) because this evaluates to {1.2.3.4.5.6.7}. In range J2:P2 column J is number 1, column K is number 2 and so on.
=IFERROR(INDEX(J2:P2,SMALL(IF(J2:P2<>"",COLUMN($A$1:$G$1)),1)),"")
The IFERROR part of the formula (highlighted in red) returns an empty cell if there isn't a name in the row.
Josue switlana