Microsoft Excel can now put multiple values in a single cell

Key Points:

• Microsoft is previewing new Excel features that allow cells to contain lists, arrays, and nested arrays, enabling multiple distinct values to be stored and managed within a single cell rather than just one value.
• The Lists feature lets users input multiple individual values separated by commas or semicolons in one cell, with improved filtering and calculation capabilities on these separate entries.
• Arrays and nested arrays inside cells enable more complex data structures and calculations, supported by new functions like FLATTEN, HAS, HASANY, and HASALL, expanding spreadsheet design possibilities for advanced users.
• These features are currently in Beta for Windows and Mac, with several limitations including incomplete support in conditional formatting, charts, PivotTables, and Power Query, and Microsoft advises against using them in critical workbooks at this stage.
• If successful, these updates could significantly enhance Excel’s flexibility and data organization capabilities by allowing more complex and multi-dimensional data to be handled within individual cells.