Forum Discussion

Scott1280's avatar
Scott1280
Copper Contributor
Aug 29, 2024

Power Query for Mac using array as data source

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.

excel
Excel on Mac

3 Replies

  • nkal24's avatar
    nkal24
    Brass Contributor
    Aug 29, 2024
    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/)
    • Scott1280's avatar
      Scott1280
      Copper Contributor
      Aug 30, 2024

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

       

      • nkal24's avatar
        nkal24
        Brass Contributor
        Aug 30, 2024

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

Resources