Excel now supports multiple values in a single cell

Microsoft shipped lists, in-cell arrays, and nested arrays to Excel Insiders Beta. A single cell can now hold multiple values that remain individually filterable and calculable, instead of being treated as plain text. Four new functions—FLATTEN, HAS, HASANY, HASALL—help flatten nested results or search by member. The post doesn't disclose a general availability date.