Try a forumula like this:
=INDEX(Sheet1!A:A,COUNTIF(Sheet1!$A:$A,"<>")-10+ROWS($A$2:$A2))
copied down 10 rows and across as far as necessary to capture all row info.
Note: This assumes no blanks in column A of other sheet (Sheet1) and it assumes you are extracting from sheet1 starting at column A.
Bookmarks