Skip Blank Cells While Copying A List
 

Hi,

Can someone please help me out with an excel formula . The solution i want is like this

The source column can have any entries with blanks in between :
apple
orange


12334
mango
5678

zcech


I need to copy this data to new column skipping blanks:

apple
orange
12334
mango
5678
zcech


I need a fomula (not macros please) and it shouldnot use row()


The formula i have tried is


if source data is in column A

write in column C
=IF(TRIM(A2)="","",ROW())

and write in column B
=IF(ISERROR(SMALL(C:C,ROWS($A$2:A2))),"",INDEX(A:A ,MATCH(SMALL(C:C,ROWS($A$2:A2)),C:C,0)))


Select both B and C and dropdown till the no f rows u want.
This formula works very well.

But the application i use (Xcelsius) doesnot support row( ) , rows( ). so i am in search of another formula.




Kindly Help ........................ Pleache



Thanks in Advance,
Shruthi