Forum Discussion
How to combine multiple excel data using power query
In attached file a query that combines all sheets in all workbooks
If this is what you want to do, update the Folder path with yours in sheet 'PARAM' > Refresh the query in sheet 'Query Result'
refer below snapshot of error message.
test1 file have single worksheet with name as sheet however remaining files have multiple worksheets like 2 or 3 but they all have different names.
Do we need to match worksheet name as well?
Are how things going with your various workbooks & worksheets 'Combination'?
can you please let me know how to apply same step to multiple queries? I have almost 26 queries and need to trim headers of those so instead of doing it one by one can we do it once for all 26 queries?
In the sample workbook I provided you the query trim the headers of all sheets in all workbooks, after promoting the headers:
TrimmedHeaders = Table.AddColumn(ExpandedSheetsAsTables, "CLEAN_HEADERS", each Table.TransformColumnNames( Table.PromoteHeaders([SHEET_TABLE], [PromoteAllScalars=true]), Text.Trim ), type table ),