hi everybody

I have some non contiguous data in an column , column A ,
from range rows 50 to 1500; aprox 40 cells .
I need a function in range A1 to show the value of the first cell with data ,
- or non blank can be say - in A2 a function to show value of the second cell wirh data , and so on , my range A1:A40 to show non contiguous
data from column A50:A1500

I really apreciate your help