Forum Discussion
ajmal_pottekattil_yoousuf
Mar 15, 2023Iron Contributor
How to combine the 6 excel workbook in to one worksheet.
I have 6 Workbook and 1000 rows in the each workbook. I needed to combine to one workbook.
Patrick2788
Mar 15, 2023Silver Contributor
PowerQuery is one way to do it:
https://support.microsoft.com/en-us/office/import-data-from-a-folder-with-multiple-files-power-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4
https://support.microsoft.com/en-us/office/import-data-from-a-folder-with-multiple-files-power-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4