Look things up
Stack two lists into one
=VSTACK(A2:A3,C2:C3)How it works in Excel
- Each range goes under the one before it.
- HSTACK puts them side by side.
- It needs Microsoft 365.
The idea in general
It piles one list on top of another, without any copying and pasting.
What I assumed
- The lists are in A2:A3 and C2:C3.
Check the result on your own data before relying on it.