shorten a long list

in column A, i have 1000 rows. there are 30 cells containing text mixed randomly throughout this column.

is there a way i can shorten this list to another column containing ONLY the cells with the text, preferably by the order from which they are listed within the original column (meaning the first entry in row 11 will be in the new column row 1, the next entry in the original column at 202 will be in the new column row 2 etc etc)

sorry for the obscure question, i dont know how to begin to properly describe my needs and how to address it

Add a helper column next to the source.. and at row 2, enter formula:

=IF(A2="","",COUNT(B$1:B1)+1)

copied down, where A2 is first cell in the column to look at and B1 is cell above the one you are in...

Then in another cell in another column enter:

=MAX(B:B) where column B is your helper columnm

Then formula to extract the values would be:

=IF(ROWS($A$1:$A1)>$C$2,"",INDEX(A:A,MATCH(ROWS($A$1:$A1),B:B)))

where C2 is the cell you placed the MAX formula in.

copied down as far as you need.