Microsoft tests a new Excel feature allowing multiple structured values per cell, including lists and nested arrays, currently being rolled out to beta users

According to cnBeta, Microsoft is testing a new Excel feature that allows a single cell to hold multiple structured values, including lists, cell arrays, and nested arrays. The feature is being rolled out to Microsoft 365 Beta users, with the capability to treat individual items as separate data for filtering and to spill results into adjacent cells. It also introduces arrays that can be stored as a whole in a cell and supports nested arrays for multi-level structures.