Hi
Try with a helper and a array formula
In I2 (helper column) use the following formula and copy down
=IFERROR(AGGREGATE(15,6,IF(--NOT(ISERROR($A$1:$E$10)),(ROW($A$1:$E$10)&"."&COLUMN($A$1:$E$10))+0,1/0),ROWS($A$1:$A1)),"")
In J2 use the formula and copy down
Formula:
=IFERROR(INDEX($A$1:$E$10,QUOTIENT(I2,1),MID(I2,FIND(".",I2)+1,9999)+0),"")
Note: The red symbol must be the decimal separator.
See the file
Bookmarks