Vstack with merged cells

Question

I want to use the formula vstack on an array to combine columns from different worksheets, it works perfect on column H and beyond but on the columns that have stacked cells(D to G), I got error #SPILL!

Is there a way to avoid it without using vba? Thanks!

Answer 1

This is from Microsoft site (https://support.microsoft.com/en-gb/office/-spill-error-spill-into-merged-cell-4a220ecc-b830-4e22-b8a6-4b86f6cf6507)

And a quote from it:

#SPILL! error - Spill into merged cell Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel for iPad More...

Spilled array formulas cannot spill into merged cells. Please un-merge the cells in question, or move the formula to another range that doesn't intersect with merged cells.