Forum Discussion

Ray_Nord's avatar
Ray_Nord
Copper Contributor
Oct 04, 2023

Consolidate tables into a single spreadsheet

How can I create a single excel spreadsheet from 180 tables (all with the same format? Ray  
excel
SanthoshKunder's avatar
SanthoshKunder
Iron Contributor
Oct 04, 2023

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!

Resources