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

[@MM-nr8nf]

You are the first to get us this information. Keep it up.

[@Officeinstructor]

The moment it was released... I created the post to share the knowledge with my subscribers.

[@wayneedmondson1065]

Hi Nabil. Wow!! That is awesome news. I don't have the functionality yet, but hope it will update soon. Thanks for previewing this new feature. Looking forward to finding out more about it :)) Thumbs up!!

[@IvanCortinas_ES]

That's awesome. But it is also available for version 2104 (No insider). Thank you for this tutorial.

[@Officeinstructor]

Thank you my friend... I corrected the video description and mentioned you there

[@vijayarjunwadkar]

That's amazing! Thanks for sharing!

[@Officeinstructor]

Thanks for watching Vijay

[@OzduSoleilDATA]

Niiiiice! Thanks for this.

[@Officeinstructor]

Thanks OZ for stopping by... and watching

[@Luciano_mp]

Thanks Nabil.

[@Officeinstructor]

You are welcome

[@GrainneDuggan_Excel]

Fantastic!!!!!!!

[@Officeinstructor]

Yes... Excel is evolving overnight

[@Abioladavid01]

Awesome feature
Though, there is a little caveat dealing with headers when source data changes and the PQ result is refreshed. The copied and pasted headers will disappear

[@Officeinstructor]

Totally agree with you my friend (and fellow MVP). It's going to be better in the near future. Thanks for stopping by my channel.

[@Abioladavid01]

@@Officeinstructor You're welcome Prof.
I certainly believe the Excel Team will fix the slight issue.
Regards

[@AnbarasuAnnamalai]

That is amazing.

[@Officeinstructor]

Agree... and it is still under discussions for improvements

[@mirrrvelll5164]

Damn!!! This is revolution!!!!

[@Officeinstructor]

Totally agree

[@HusseinKorish]

Amazing

[@Officeinstructor]

lots of potentials

[@Stef1955]

Wow! OMG!

[@Officeinstructor]

Trying to teach and entertain at the same time :)