Create a report without blanks

[SimonDavid2360]

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

[#2]

@SimonDavid2360 

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.

Nikolino

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.