From Dynamic Arrays- Just Released in Power Query

At first glance I thought it is just a change in the name of a button From "From Table/Range" to the new name "From Sheet". However the surprise was in the new descriptive tooltip where I discovered that now you can send a Spilled Array range to the Query editor. That opens the door to a lot more functionalities. At the time of posting, this option is available in my version of Microsoft 365 Version 2105 (Insider). Thanks to my friend Ivan Cortinas who informed me that it's also available in Version 2104

Category