I've got a Google Sheet I'm creating for settlement purposes and I have 8 variables that only get used sometimes. Each variable has its own line devoted to it. For example, this load has a scale charge that is visible in the image I posted (but the other 7 rows are blank in the Row 14-21 range).
The data is getting pulled in from a master sheet but I'd like the empty rows to be of MINIMAL HEIGHT by default and then expand ONLY IF any data is actually present to be displayed for a particular variable.
Why do I need to do this, you ask? For space saving purposes for printing since most settlements will have multiple loads. I'd prefer not to leave 8 lines of BLANK SPACE fully expanded all the time for each load for paper-saving & aesthetic purposes. Any ideas?