Hi
Array formula below concaniates up to 4 words
=IF(B2="All Segments",TRIM(IFERROR(INDEX(OFFSET(B2,1,0,MATCH("All Segments",$B3:$B19,0)-1,1),1),"")&" "&IFERROR(INDEX(OFFSET(B2,1,0,MATCH("All Segments",$B3:$B19,0)-1,1),2),"")&" "&IFERROR(INDEX(OFFSET(B2,1,0,MATCH("All Segments",$B3:$B19,0)-1,1),3),"")&" "&IFERROR(INDEX(OFFSET(B2,1,0,MATCH("All Segments",$B3:$B19,0)-1,1),4),"")),"")
Bookmarks