Dear experts,
I have a number of workbook received everyday with inconsistent filename and sheetnames.
I want that all workbooks with column name "Welding date" to be merge.
Please note the "Welding date" is at column AB1.
I want that all column names from Column A1 to column AB1 be part of the merge.
Please can you help me figure out the Power query formula.
Thank you in advance experts appreciated.
Regards,
12Rev79
I have a number of workbook received everyday with inconsistent filename and sheetnames.
I want that all workbooks with column name "Welding date" to be merge.
Please note the "Welding date" is at column AB1.
I want that all column names from Column A1 to column AB1 be part of the merge.
Please can you help me figure out the Power query formula.
Thank you in advance experts appreciated.
Regards,
12Rev79