Consolidate tables into a single spreadsheet

[Ray_Nord]

How can I create a single excel spreadsheet from 180 tables (all with the same format?

Ray

[#2]

https://b23.tv/JRHUkHH

[#3]

@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!