Enter data for filtering

Is there any specific reason for this setup? Generally speaking, this type of setup makes it very hard to analyze the data, rendering many of Excel's features useless.

As BigBas says, You would do better to have 6 colums across and no blank lines. That way you can sort and filter as much as you like.

Ed

The specific reason for this is due to the print out.

I would like to have about 15 different cells to fill out and keep them on 1 page. When I have them all in 1 row i get 2 pages in length (landscape is on) and it's hard to read the data that way.

OK,

I would have two sheets. The first would contain the raw data in rows, the second would pull the data out and present it as you want.

That way you can filter and sort the data and still have it presented in the way you want.

Ed