There’s several ways to combine lists in Excel. You can copy and paste (just because you can doesn’t mean you should!); you can use Append Queries in Power Query and you can use VBA.
Microsoft 365 subscribers now have another way. Excel’s VSTACK function is used to quickly combine multiple lists into a single list. Whether you’re working with large datasets or just need to merge a few rows or columns, the VSTACK function can help you do it all with just a few simple steps. Need a sorted list? Simply nest the VSTACK function inside the SORT function!
This short 5-minute video shows you how to do it