Multi select dropdown lists in Google Sheets & unpivot for analysis

Google Sheets introduced multi select drop down lists, I go through how to make them and more importantly how to analyse the results from them, which involves some complex formulas.

How to make them is in the first 90 seconds but how to analyse them comes later to make this video longer.

To download example workbooks, enter email here: https://www.xlconsulting-asia.com/socials.html

Some other related videos:
QUERY function: https://youtu.be/4pdwoLGhzJ4
Unpivot with FLATTEN: https://youtu.be/lCB6aXcQdV4
Dynamic arrays in G Sheets: https://youtu.be/14Uo4gMRsFw
Data validation/dropdowns: https://youtu.be/v4eQAo541dk

00:00 Introduction
00:19 Multi select drop downs
01:37 Limitations
02:40 Split into multiple cols
04:28 Search for contains
06:00 Unpivoting via complex functions