best way to make data managable?

[footer]

I have several sheets that are forms, most have linked cells with zero vales in places. when the forms are completed I have a lot of blank rows that I need to get rid of. I have made forms into tables and unchecked blanks then cut/paste into a new area the deleted origal and pasted vales back. is the a better way for me to do this?

Cherry, Natural
1/4" Rail Stock 8' finished
SPECIES Qty Width
Cherry, Natural 15 1.5
10 1.75
4 3
2 6
4 2.25









Total 1/4" Rail Stock 35
Cherry, Natural
1/4" Ply
SPECIES Qty Width Height
Cherry, Natural 2 13 44
1 25 36
1 70 96
1 48 96
1 26 96



Total 1/4" Ply 6

[newdoverman]

An arrangement of data like this would likely be better:

[footer]

An arrangement of data like this would likely be better:

I agree that would be a much better layout but at this point it is not a good option due to the number of sheets that I have that are laid-out similar

[newdoverman]

This may be the basis of a solution. I may come up with more with more time to think about it.

[newdoverman]

I think that I have "cracked" the problem of the data format. Take a look and see if it meets your requirements.