Consolidate Data, Combine Text, and Calculate Age

[VtQuest]

I am working with a spreadsheet regarding housing for homeless people. The people are represented by ID numbers. There are many duplicates. I want to sum SOME of the values associated with the IDs while also combining text notes. The values I wish to sum are Number of Nights. I wish to combine the text in the Causes column and in the Housing Authorized column (separately). I’d also like to calculate age from birthdates, and number of calls based on call date. (Call date is not listed in the first example.)

I have familiarity with Excel in its simple form, not at this level. (I’m sure, to some people, this is pretty simple, but not to me - yet.) So, I’m not familiar with many formula terms or query tools. Please respond with this in mind.

The first image is a sample of the data, with identifying information obscured. The second image is of the desired result.

Thank you for your help.

 

[VtQuest]

Hi Paul,

As always, you are of great assistance! I'll ponder those options but in the meantime will see how we can use the reports for my homelessness report.

No one really knows how many people are lacking permanent, consistent housing - anywhere, whether in the UK (I assume) or US. So, estimates are conjured up. We hope this report will provide a broader view of those who are in that situation. Many, many thanks for your contributions to our effort.

I realize that the guidelines of this forum do not allow for emailing members or getting their address. If the latter was possible, you'd be sent one of Vermont's most well-known products, maple syrup. And, some of our Vermont 211 swag.

Best Regards,
Beth