One way which makes it dynamic to source data in col A

In B1:
=IF(ROW()COUNT(C:C),"",INDEX(A:A,SMALL(C:C,ROW()) ))

In C1:
=IF(A1="","",ROW())

Select B1:C1, copy down to cover the max expected extent of data in col A.
Hide away col C. Col B will return the required results.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Vincent" wrote:
Hi everyone,

i guess its easier to explain with an example.

I have:

A1 acb
A2
A3 fff
A4
A5
A6
A7 fre
A8


I want:

B1 acb
B2 fff
B3 fre


Best Regards to everyone