Forum Discussion

kite21's avatar
kite21
Copper Contributor
Sep 06, 2023
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 would like to avoid having to refresh Power Query each time in order for the data in the 3rd sheet to be updated.

 

Thanks for reading.

excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Sep 06, 2023

    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.

     

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Sep 06, 2023

    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.

     

Resources