Google Spreadsheet Post #1091
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr 1, 2013
user RKL1 :(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/2J7cZmQkGs8)
I am trying to query data that has a lot of empty cells
when I use the query function
I am left with empty rows in the output. Is there a way avoid empty rows and have the data output compacted?
and the result is the same.
This is my spreadsheet. The two equations are under cells E32 and E50.