I need to mimic an Access report in Excel.
The report is based on a flat file where dates repeat and contract numbers repeat.
Essentially, I’d like to do something like a vlookup, but feel it may be a simpler way.
I have the following information in rows as my source
Contract Name...