Repeat one column number of times there is text in another

Originally Posted by XOR LX

Or, if you prefer the Members to be listed in order, then, assuming that the data you give is in the range A1:D3, enter these array (important!) formulas:

For your Members list (enter in cell I1 and copy down as required):

=IFERROR("Member "&SMALL(IF($B$1:$D$3<>"",--TRIM(SUBSTITUTE($B$1:$D$3,"Member",""))),ROWS($1:1)),"")

For your Group list (enter in cell J1 and copy down as required):

=IFERROR(INDEX($A$1:$A$3,SMALL(IF(($B$1:$D$3=I1)*($B$1:$D$3<>""),ROW($B$1:$D$3)-MIN(ROW($B$1:$D$3))+1),COUNTIF($I$1:$I1,I1))),"")

Regards

I tried using this but it gave me an error at the first "" ($B$1:$D$3<>""). Thank you very much for your efforts.