Power Query for Mac using array as data source

[Scott1280]

Its not obvious to me how to connect  an array as the data source for my Power Query on Mac.  I have seen some videos that show connecting to Ranges and Tables using a PC.

[#2]

I found this add-in some time ago:

[MoreQuery for Mac | MrExcel Message Board](https://www.mrexcel.com/board/excel-articles/morequery-for-mac.68/)

[#3]

Thank you @nkal24 .  I will give this a look.  The Microsoft / Apple feud continues with Mac Excel always lagging in new features vs PC.

[#4]

@Scott1280 Excel on Mac is beautiful, I also wish that its functionality is identical to the Windows version.