works perfecty both

For the column try in A1:
=SMALL(IF($AE$1:$AX$1<"",COLUMN($AE$1:$AX$1)),CO LUMN(A1))

for this above one , is my last request on today ;
to change rows instead columns, and bring the adress number of
the row with data ,
for below range adress :

=INDEX($A$101:$A$1500,SMALL(IF($A$101:$A$1500<"", ROW($1:$1400)),ROW(A1)))