Create a report without blanks

Occasional Contributor
Hi, I have a spreadsheet for our food bank. One page has a column for the name of the more than 300 families that are registered another with a reference number (alpha numeric) and then the next series of columns for the weekly collection dates. Not every family gets food every week soI want to generate 2 reports. The first based on date to give a list of who was fed and a second based on the reference number of which dates the family was given food. The main thing I want to achieve is for the reports not to be full of blanks. Thanks in advance
1 Reply


I'm not sure if this is what you are looking for, but here is a solution that may make your work a little easier.


I would be happy to know if I could help.



I know I don't know anything (Socrates)


* Mark and Vote if it helps please, as it will be beneficial to more Community members reading here.