Forum Discussion
Looking for quick way to merge 188 excel tables into one spreadsheet
I have 188 excel tables that I wish to merge into a single spreadsheet. Tables are all formatted the same. I know that I can copy and paste them individually to a spreadsheet but I am looking for an ...
you can use power query or use a formula like:
=VSTACK(Sheet1!A1:ZZ1, Sheet1:Sheet188!A2:ZZ999)
of course adjust the sheet names and range accordingly and I'm assuming the header is the same on each so I take it from 1 sheet and start on row 2 on the rest.
Once done you can Copy and then Paste as Values if you want to delete the original sheets.
=VSTACK(Sheet1!A1:ZZ1, Sheet1:Sheet188!A2:ZZ999)
of course adjust the sheet names and range accordingly and I'm assuming the header is the same on each so I take it from 1 sheet and start on row 2 on the rest.
Once done you can Copy and then Paste as Values if you want to delete the original sheets.