Forum Discussion

slohombre's avatar
slohombre
Brass Contributor
May 23, 2020

Power Query: Source Files Column Order

Hi, all. I am about to do a Power Query of two excel files that have the same column headers and data types but the order of the columns is slightly different. Does Power Query care if the order of the columns are different in one file versus the other? Thanks for any help.

excel

4 Replies

    • slohombre's avatar
      slohombre
      Brass Contributor
      May 23, 2020

      SergeiBaklan Yes - that is what I mean. So the order of the columns does not matter between the two files as long as they have identical header names and data types.

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        May 23, 2020

        slohombre 

        Yes, and hope nothing changes in recent versions - I didn't check right now. But that's easy to test, few minutes job - create two files with couple of rows each, first have columns A, B, C; second with columns C, B, A. Or like. Query the folder with them, combine and transform, check result, delete files.

Resources