I am trying to collate date in Google Sheets. I have multiple tabs and want to consolidate them into one tab where each row is from a different tab. If that doesn't make sense, here is my test spreadsheet.
Tab 1:
Green1 GreenCol1 GreenTest1
Green2 GreenCol2 GreenTest2
Tab 2:
Yellow1 YellowCol1 YellowTest1
Yellow2 YellowCol2 YellowTest2
And so on for however many tabs. What I want to output on the "Master Tab" would be something like this
Master Tab:
Green1 GreenCol1 GreenTest1
Yellow1 YellowCol1 YellowTest1
Green2 GreenCol2 GreenTest2
Yellow2 YellowCol2 YellowTest2
I have the following code currently in A1 of my master tab, but it returns all of the green then all of the yellow, which is what I am trying to avoid.
=QUERY({Sheet2!A1:C;Sheet3!A1:C},"select * where Col1 is not null",0)