Forum Discussion

Recoba88's avatar
Recoba88
Helper III
9 years ago

Consolidate multiple excel files into one

Hi,

 

 

When I try to open all columns (for all files) I get the columns in alphabetic order, but I want to get them in the same order they appear in my workbooks. How can I do it?

 

 

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Recoba88,

     

    You can try to use "Tabel.Combine" or Expand feature to achieve your requirement.

     

    Sample:

    ExpandTable: Click on the top right expand arrow to expand the table.

    Table.Combine: Modify your formula to Table.Combine(Table.SleectColumns(#"Removed Error",{"Custom"})[Custom])

     

    Regards,

    Xiaoxin Sheng