Forum Discussion
Solved
Append rows from multiple sheets into new sheet without using Power Query?
Suppose I have a workbook with 2 sheets that both have exactly the same columns. Is it possible to append all the rows from the 2 sheets into a 3rd sheet using a formula rather than Power Query? I wo...
kite21 If you have Excel365 you can use the VSTACK function. See image below.
=VSTACK(Table1[#All],Table2)Imagine the tables are each in their own sheet, then you can enter the formula shown in H2 in a third sheet.
kite21 If you have Excel365 you can use the VSTACK function. See image below.
=VSTACK(Table1[#All],Table2)Imagine the tables are each in their own sheet, then you can enter the formula shown in H2 in a third sheet.
- Thank you, Riny_van_Eekelen. This was what I needed.
