Forum Discussion
Consolidate tables into a single spreadsheet
How can I create a single excel spreadsheet from 180 tables (all with the same format?
Ray
2 Replies
Ray_Nord -
- Power query is an ideal option!
- VSTACK formula also does the job here. Of course you need to adjust the range and sheet name.
=VSTACK(A1:A1,'S1:S4'!A2:A3)- You can do it with the help of Command Prompt too!
