I recently learned from MyOnlineTraingHub that Microsoft recently released a new feature allowing lists, arrays, and nested arrays to be stored in single cells. This feature is currently only available on the Beta Channel for Microsoft 365 Insiders, but it will be interesting to see how this interacts with pyxll cache objects, when it becomes generally available.
See the YouTube video for more details: