Thread: Stack multiple tables on top of each other in a single table
View Single Post
 
Old 04-18-2021, 03:24 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Quote:
Originally Posted by Remko View Post
How can I make result table to always be correct without any manual calculation or use of macros?
Use Google sheets!


Code:
=SORT({Sheet2!A2:D;Sheet3!A2:D;Sheet4!A2:D}
or:
Code:
=query({Sheet2!A1:D;Sheet3!A2:D;Sheet4!A2:D},"select * where Col1 is not null",1)
Reply With Quote