Share via

Stack Multiple Uneven Columns

Anonymous
2022-08-23T13:45:27+00:00

I would like to stack multiple uneven columns into one main column by selecting the range A2:E9. I don't have VSTACK in my excel. Any other alternative formula to stack columns.

Its easy to do it with VBA by selecting the range or entering the range in input box. But formula would get updated instantly if I change the range.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-08-24T10:25:37+00:00

    Thank you very much for the formula solution. That's exactly what I needed dynamic array formula that spills. Good use of FILTERXML.

    Could you explain what //y signify how does it refer to SUBSTITUTE text?

    I replaced //y to //x/y as per the syntax.

    Could you direct me to any source for using different XML functions like first().

    0 comments