Forum Discussion
Rename Columns in Sample File Dinamically
Dear Colleagues, I need to append together several excel files on a quarterly basis. The Date is structured the same way (4 columns, first the product, then one column for each month of the quart...
Hello, RobGer
let
a = table_A,
b = table_B,
c_names = {"Item"} & List.Skip(Table.ColumnNames(a)),
tbl =
Table.FromRows(
List.Combine({Table.ToRows(a), Table.ToRows(b)}),
c_names
)
in
tbl
Hello AlienSx,
I use as source a Sharepoint Folder, where I upload all the files each quarter. Wenn I pull this Folder into Power Query and combine, I get an error (presumably because of the Sheet name, as it is auto generated by the software from where the data comes from). So instead of directly combining the content of all Excel Files (which I can't because of the sheet names), how could I combine the files, independently of sheet name?