Create a report without blanks

%3CLINGO-SUB%20id%3D%22lingo-sub-2241208%22%20slang%3D%22en-US%22%3ECreate%20a%20report%20without%20blanks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2241208%22%20slang%3D%22en-US%22%3EHi%2C%20I%20have%20a%20spreadsheet%20for%20our%20food%20bank.%20One%20page%20has%20a%20column%20for%20the%20name%20of%20the%20more%20than%20300%20families%20that%20are%20registered%20another%20with%20a%20reference%20number%20(alpha%20numeric)%20and%20then%20the%20next%20series%20of%20columns%20for%20the%20weekly%20collection%20dates.%20Not%20every%20family%20gets%20food%20every%20week%20soI%20want%20to%20generate%202%20reports.%20The%20first%20based%20on%20date%20to%20give%20a%20list%20of%20who%20was%20fed%20and%20a%20second%20based%20on%20the%20reference%20number%20of%20which%20dates%20the%20family%20was%20given%20food.%20The%20main%20thing%20I%20want%20to%20achieve%20is%20for%20the%20reports%20not%20to%20be%20full%20of%20blanks.%20Thanks%20in%20advance%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2241208%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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

@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.