Forum Discussion

ajmal_pottekattil_yoousuf

Iron Contributor

Mar 15, 2023

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.

1 Reply

Patrick2788
Silver Contributor
Mar 15, 2023
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

Resources