Submission + - Put Multiple Values in One Cell with Lists and Arrays in Excel 1
"Throughout Excel's 40-year history, you've only been able to put one value per cell. In this announcement, we're excited to share how that's changing with the release of lists, arrays in cells, and nested arrays, initially to Microsoft Excel for Windows and Mac Beta Channels. Many workbooks already try to pack multiple values into one cell. A project might list 'Carlos, Henrietta, Jacob' as three owners, or a Forms survey might return '2:00 PM; 2:30 PM; 3:00 PM' as one response. With lists, you can keep those values in one cell, while also keeping them separate for filtering, calculation and more."
If you haven't been keeping abreast of What's New in Excel, Microsoft has added a number of new features over the past years that enable Excel users to do things one might formerly have turned to programming languages and other computing environments to accomplish, including support for regular expressions, the LET and LAMDA functions, Python in Excel, and, of course, the obligatory AI support.
Which raises an interesting question: Is an Excel formula worth a thousand lines of AI-generated Python code? (especially if the latter is run in an overengineered infrastructure, such as an AI-generated complex CI/CD pipeline combined with cloud pipeline execution!)