Hiding Cells...

Hello All,

I am relatively new to Excel beyond very basic formulas and I wanted to see if you guys could help me get what seems like a fairly easy question answered. (I stole the current formulas from what a previous manager used for a different sheet if you're curious as to how I even got to the point I did). What I have now is the far Lane in the "Data" sheet coordinating to the "Cooler Outline" sheet. When I put a number in the "Lane #" column it shows up with the desired information in the "Cooler Outline." My only problem is all the blanks. I'd love to have it so any of the empty rows or even columns that aren't filled get sorted out. I tried to use a table to do this but the way the info is I couldn't figure how to do this... All the info I tried to pull had me deleting blanks or trying to get rid of every blank one but the work space. Any help is appreciated!

Best,
Jake