Forum Discussion

Saeed716's avatar
Saeed716
Copper Contributor
Jan 06, 2020

Power Query “Combine & Load”

In Power Query, I was having Combine And load option and when i do that. It would give me my data combined in two columns. 1. File name 2. Data in it. Now my excel is upgraded to new version. There it does not show my that combine n load screen. I want to know how can i do the same with this new version. I have attached the old version where it shows the option. Please help as this was saving my time alot

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Saeed716 

    On which version of Excel you are now? I guess we speak about From File->From Folder connector. If so, Combine and Load is still here, I'm on

     

    • Saeed716's avatar
      Saeed716
      Copper Contributor
      I am on Microsoft Excel with an Office 365 subscription that has the latest version of Excel.. there in, i dont find this option. There are options to combine binaries but when i do. I dont find my file names to the left. I am confused. Please Help me on it.
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor

        Saeed716 

        Could you please specify which exactly connector do you use and the screenshort of the new version with options you see.

Resources