How to remove blank lines from VLookup or IF statement spreadsheet

I have a workbook that has a worksheet that contains information for many individuals from different towns. I am trying to set up individual worksheets within the workbook for each town. On the individual worksheet, I want to list all information for the individual from the main worksheet. My question is, I can use VLookup or IF statements to get the information over but it creates blank lines. How do I get these blank lines to not be there. I know this would be better in Access and that I can use a quick filter on my main sheet but I would like to see if I can get Excel to do this.

Thank you for you help

Let's say the town is in column F of sheet 1 starting at F2 and your last column of data is G

In H2 of sheet1
=F2 &"_"&COUNTIF($F$2:$F2, F2)
copied down the sheet

Let's say sheet2 is for Turnipville and you want all the same columns but just the ones for Turnipville
In A2
=INDEX(Sheet1!A$2:A$100, MATCH("Turnipville_"&ROWS($A$1:$A1), Sheet1!$H$2:$H$100,0))
copied down.
might be easier to follow if you uploaded an example (Go Advanced>Manage Attachments)

Thank you. I will try to upload it in a minute. One question on the second formula. Why do you use !A$2:A$100 from sheet 1?

Workbook should be attached.Attachment 372527

Try this array formula. in A4 and pull formula to the very right and then down

=IFERROR(INDEX(Summary!A$2:A$19,SMALL(IF(Summary!$A$2:$A$19<>"",ROW(Summary!A$2:A$19)-ROW($A$2)+1),ROWS(A$1:A1))),"")

Sorry, I din't see this mentioned anywhere. Here is an adjusted formula

=IFERROR(INDEX(Summary!A$2:A$19,SMALL(IF((Summary!$A$2:$A$19="Turnipville")*(Summary!$A$2:$A$19<>""),ROW(Summary!A$2:A$19)-ROW($A$2)+1),ROWS(A$1:A1))),"")

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

You're welcome. Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).