How can I get Away Team and append them to the last row of Home Team (Being Home or Away doesn't matter, in this case), and get AST and append to HST. I 'd see Date being repeated so as to keep data consistent.
I've tried combining query() with importrange(), filter(), etc, but without any luck so far.
Here's the data:
Any help is appreciated.
Regards,
Try
={flatten({A2:A,A2:A}),flatten({B2:B,B2:B}), flatten(C2:D),flatten(E2:F)}
or according to your local parameters
={flatten({A2:A\A2:A})\flatten({B2:B\B2:B})\ flatten(C2:D)\flatten(E2:F)}
FLATTEN combines data alternately. With range merging, lists can be merged one after the other.
={C2:INDEX(C:C,MATCH(TRUE,C:C="",0)-1);D2:INDEX(D:D,MATCH(TRUE,D:D="",0))}
