Let's say we have two columns/ranges
A1:A10 (group A) and
B5:B50 (group B) and we need to merge the two into one column in
C1:C60 (60 in C = 10 from A + 50 from B)
Data in group A & group B can go up/down unpredictable.
I google and found this trick but that works on constant number of cells of each group.
How would we merge such dynamic ranges quickly?