Only keep non-blank rows

Thanks for your reply.
I have replaced the pictures with a small sample sheet.

Put this formula in I2 of Sheet1:

=IF(COUNTIF(A2:H2,"?*"),MAX(I$1:I1)+1,"-")

Copy this down as far as you need to in order to include all your data - the hyphens will indicate where the formula is active.

Then in A2 of Sheet2 you can use this formula:

=IF(ROWS($1:1)>MAX(Sheet1!$I:$I),"",INDEX(Sheet1!A:A,MATCH(ROWS($1:1),Sheet1!$I:$I,0)))

Copy this across into H2, then copy all those formulae down as far as you need to (until you start to get blanks).

Hope this helps.

Pete

Thanks a lot, Pete_UK

You're welcome.

I forgot to mention that you will probably have to use semicolons ( ; ) instead of commas ( , ) in the formulae, but presumably you sussed that out yourself.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete