Multiple data points into one cell

Question

At my company, we have a spreadsheet to track "Site Visits". In this sheet, we create on row per visit to a given project. We also have an "Inspection Log", in which each project has one row per unit of residence. My task is to figure out if I can populate the "Unit#/Address" field of the "Site Visits Log" automatically from the "Inspection Log".

So if I enter today's date into three rows in one project within the Inspection Log, then I would want Excel to enter the unit# or address of each row that contains today's date into the Site Visit Log, ... where my boss does his billing from.

This would reduce the amount of data entry required from our field techs, and also reduce the likelihood of mistakes.

I'm looking at Power Query as a potential solution. Can anyone help to point me in the right direction?

I am using MS Excel desktop app, though my MS365 account. So in my account panel from a spreadsheet, MS says that i'm running Version 2210.

Answer 1

Hi,

Share some data to work with and show the expected result.

Answer 2

You can use logic like this

=TEXTJOIN(TRANSPOSE(FILTER(AddressRanges, DateRange=CellWithDate of Interest)))

kind of like.... hard to be better without the actual workbook

=TEXTJOIN(", ",,TRANSPOSE(FILTER('Inspection Log'!A1:A100, 'Inspection Log'!B1:B100=A2)))