Rept value by count x in rows

How to show like in "Result" in my snapshotIMG_20210420_054759.jpg

Maybe try at A10

=IFERROR(INDEX($A$4:$A$7,MATCH(ROWS(A$10:A10),MMULT(N(ROW($B$4:$E$7)>TRANSPOSE(ROW($B$4:$E$7))),MMULT(N($B$4:$E$7="x"),TRANSPOSE(COLUMN($B$4:$E$7))^0))+1,)),"")

Ctrl+Shift+Enter

Try this.
ARRAY formula In A10 then copy down

Please Login or Register  to view this content.

Thank all worked