The user who posted this problem has spent years as the most computer literate person in their office, and they are still fighting a 15-year-old manual report. That is not a skill gap. That is a tool gap. The spreadsheet they are using was never designed to handle the kind of relational, multi-value data their database naturally produces. When a case has multiple pets or multiple visits, the database correctly outputs multiple rows. Excel, built for flat tables, then forces those rows into a structure where each case must occupy exactly one row for a mail merge. The user is left writing nested IF functions and chasing UNIQUE formulas that refuse to work with blank cells. The spreadsheet is not helping them. It is making them compensate for its limitations.
This is exactly where AI-native spreadsheet technology changes the equation. The core problem here, extracting a unique list of pet names from a repeating set of case IDs, is a pattern-matching and data-shaping task that traditional formulas handle poorly. UNIQUE and FILTER are powerful, but they assume clean, contiguous ranges and empty cells underneath. Real-world data is never that tidy. An AI-native approach can interpret the intent: "For each case ID, give me a list of distinct pet names, then spread them across columns." It can handle the variable number of pets, the blank cells, and the inconsistent row structure without requiring the user to build a custom formula for every edge case. The user should not have to outthink their own tool.
What makes this story so familiar is the resignation in the post: "There is nothing I can do about this. It is how reports are generated." That sentence captures the frustration of millions of spreadsheet users who have accepted that their data must be contorted to fit their software. The user has already automated the hard parts, generating the HTML report, importing it, running mail merge. They are stuck on a single transformation step that should be trivial. An AI-native spreadsheet would let them describe the desired output in plain language and get it done. No workarounds. No 15-year manual process.
The lesson here is not that the user needs to learn more formulas. It is that the tool should meet them where they are. If you are spending your time figuring out how to make UNIQUE work with blank cells, you are not spending your time on the work that matters. The future of data management is not about making users smarter about their spreadsheets. It is about making spreadsheets smart enough to understand what their users actually need.