I’m trying to combine a few datasets together using VStack and Offset

Vstack because the data is in different areas, and Offset because the data in the range varies (sometimes even being empty)

=VSTACK(OFFSET( B2,0,0,COUNTA(B2:B4),2),OFFSET( E2,0,0,COUNTA(E2:E4),2))

This is my formula (simplified for my query here and so I don’t have to show sensitive data

As you can see from screenshot it works fine when there is data in the ranges, but if the range happens to be empty (which is possible with my real life data)

The Formula errors out (I know it’s because my 2nd offset is also returning an error) I’ve tried using iferror() to cater for this
And even some if statements within but I can’t seem to get around this, end up with a row of #N/A which I don’t won’t

Image below with some options I’ve tried