I've 2 tabs, it names Class A and Class B, like this :
And my question is How to merge this data into 1 result with query? And I want the result is just like this:
For the link: https://docs.google.com/spreadsheets/d/1xmUMlprKNh1r6O81KuLtaNOQchx5sYn_ihirkG9tzWk/edit?usp=sharing Thanks in advance
try:
=QUERY({
QUERY('Class A'!A3:A, "select 'Class A',A");
QUERY('Class B'!A3:A, "select 'Class B',A")},
"where Col2 is not null", 0)
=INDEX(QUERY(SPLIT({
IF('Class A'!A3:A="",,'Class A'!A1&"♦"&'Class A'!A3:A);
IF('Class B'!A3:A="",,'Class B'!A1&"♦"&'Class B'!A3:A)}, "♦"),
"where Col2 is not null", 0))
