Power Query adding sequential columns

Hi, 
Can you provide an example for your data?

Hi jbot , I don't think that's possible by creating multiple tables/power query.
You could Read all the files (assuming they contain same data), and do a pivot to make the file name the header and load them into excel. This way all new files will appear as a new column to the right of existing columns.

Better if you have a sample/screenshot of what you are trying to achieve

Hi jbot,

May we know how exactly you are creating the query to overwrite the column, based on that information we will look for possible suggestions to reorder the column in correct way.

Also in this forum you will find people who are good at Fabric and Power BI if you believe your query can be resolved by people who are good at Excel and who have experience using powerquery within Excel, you can utilize Excel community: Welcome to the Excel Community | Microsoft Community Hub 

Thanks and Regards

You'll want to connect to the folder with all the workbooks, transform them all at once in a list so that you've got the list of single columns from each workbook, then convert that into a table. As new workbooks are added into the folder, new columns will get added.

Here is the M with some examples. I'm assuming that the data are of different shapes in the workbooks.

sample1.xlsx

sample2.xlsx

sample3.xlsx

FYI these are all just entered simply in Sheet1 of each workbook:

Now, I start with just samples 1-2 in a local folder:

Here is M that converts this into two columns:

let
    Source = Folder.Files("<local folder location with xlsx>"),

    //main initial action is to parse workbooks into a list
    ParseExcel = List.Transform( Source[Content], Excel.Workbook ), 

    //now we can do whatever series of transformations we need that will
    //convert each list item / workbook into a single list (column) of data
    WhateverTransformsToOneColEach = 
    //I'm doing a bunch of transforms at once here,
    //but you can take whatever approach you want.
    //The main thing is that the output needs to be 
    //a list of column data per workbook
    List.Transform( 
        ParseExcel, 
        each let 
            openSheet1 = _{[Name="Sheet1"]}[Data],
            promoteHeaders = Table.PromoteHeaders( openSheet1 ),
            tableToCols = Table.ToColumns( promoteHeaders ),
            combineColsIntoOne = List.Combine( tableToCols )
        in
            combineColsIntoOne
    ),

    ToTable = Table.FromColumns( WhateverTransformsToOneColEach )

in
    ToTable

What I mean by "output needs to be a list of column data per workbook" - this is the output of my WhateverTransformsToOneColEach step showing preview of each workbook output / list item:

Output on load (including some random data in columns to left to mimic your setup):

Now, I'll drop in sample3.xlsx

And hit refresh in my workbook - the parsing in our query, the <WhateverTransformsToOneColEach> part, needs to be able to handle whatever shape sample3.xlsx or any new workbooks will be in:

Hi jbot 

May I ask if you have resolved this issue by the reply provided by MarkLaf ? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.