This is a story about a user who has spent six years running tests on devices, logging every result, and now needs to make sense of it all. The problem is not the data itself, it is the shape of it. Every six months, a new row, a new date, a new pass or fail. The user wants a single row per device, with columns stretching horizontally across time: Jul '20 result, Jan '21 result, and so on. They tried pivot tables, Get Data, XLOOKUP. Nothing worked. That frustration is familiar to anyone who has ever asked a spreadsheet to think like a database.
Our take is straightforward: the user is not asking for a better formula. They are asking for a fundamentally different approach to data. Traditional spreadsheets treat each cell as an independent container. You point XLOOKUP at a range, it finds a match, and returns a value. But when your data is scattered across six years and hundreds of devices, the real need is not a lookup, it is a transformation. You need to reshape the entire table so that time becomes columns, and each device becomes a single, complete record. That is not a formula problem. That is a data-modeling problem.
What this means in practical terms is that the user's time is better spent on a tool that understands relationships, not just coordinates. An AI-native spreadsheet can look at the pattern: device ID repeats, test dates are regular, results are binary. It can infer that the user wants a pivot of time across the top and device IDs down the side, then fill in the pass or fail for each intersection. No manual pivot table setup, no nested XLOOKUPs, no wrestling with how to handle the first empty cell. The AI reads the intent from the data structure itself and offers the transformation directly. The user stops being a formula debugger and starts being an analyst again.
The deeper point here is that this user is not alone. Countless professionals have years of test logs, inspection records, sensor readings, or survey results trapped in long, thin tables. They know the answer is in there, but the tool keeps asking them to translate their question into arcane syntax. An AI-native spreadsheet changes that equation. It meets the user where they are: six years of data, a clear question, and no patience for another failed lookup. The right response is not a better formula. It is a tool that sees the shape of the problem and offers the solution before the user has to ask twice.