Multi select dropdown lists in Google Sheets & unpivot for analysis

[@McKaySavage]

Excellent video David and very clear for one of the more complex topics. Unpivot is such a useful skill, but so rarely covered. Thanks for explaining it so well. Personally I use CHOOSECOLS more often than HSTACK for rearranging ranges as the syntax is easier and way quicker to change later.

[@learnspreadsheets]

Thanks for the feedback!! Glad you like it, yes CHOOSECOLS works well too that’s a great idea!

[@alexetchart7313]

Really clear helpful video. Btw, am I very confused? In my up to date chrome browser I can't access the multi select drop down list. Is it in a beta? I can't see the option anywhere and when I click on Help menu > Updates the last changes with info are logged from March 2024. Thanks.

[@McKaySavage]

most of the time these new features are rolled out to people over a 2-6 week period so it might likely be that you just aren't in the first batch. Give it a few weeks and it'll likely show up. Frustrating to wait, but that seems to be the way of it :)

[@alexetchart7313]

@@McKaySavage Thanks so much for replying. That makes more sense. Indeed it is available now!

[@learnspreadsheets]

Hi it’s not in beta but the rollout takes a few weeks to hit all users, maybe check again & see if you have it now?

[@alexetchart7313]

@@learnspreadsheets Yeah in fact it was available just 2 days after your first reply, thank you :^)

[@keithmerrill4058]

Can you do the same thing with the date column?

[@learnspreadsheets]

If they are static values yes, but not for any date