Forum Discussion

Ray_Nord's avatar
Ray_Nord
Copper Contributor
Oct 03, 2023

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 easier method

Ray

excel

1 Reply

Sort By
  • mtarler's avatar
    mtarler
    Silver Contributor
    Oct 03, 2023
    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.

Resources