Hi, I have the following array formula
Formula: copy to clipboard 
=IFERROR(INDEX($F$2:$F$22,SMALL(IF($F$2:$F$22<>"",ROW($F$2:$F$22)-1),COLUMN(A:A))),"")
which I've to pull down 100 rows.
I have kept the reference locked because it has to be pulled across columns also.

Presently, I am manually editing the reference for each row ( Eg: changing F2:F22 to G2:G22) which is taking a lot of time.

Please provide a solution


Regards