You probably have invisible whitespaces in col B, which TRIM can handle

Just replace the formula in C1 with this:
=IF(AND(Sheet1!A1="",TRIM(Sheet1!B1)=""),"",IF(AND (Sheet1!A1<"",TRIM(Sheet1!B1)=""),10^10+ROW(),She et1!B1+ROW()/10^10))
Copy C1 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"daniellchiu via OfficeKB.com" <u36625@uwe wrote in message
news:79db2161f0e03@uwe...
Thanks!! it work but i also got 1 problem-
cause Sheet 1 col B data may contain empty cell, then I can't generate the
table.

P.S. Col A data wont be change, and always contain values.