Forum Discussion
Combaining two excel sheet data to single excel
Combining two excel sheets to one sheet.
1 Reply
due to the lack of any further information, here are my advises
1. copy & paste (but I assume this is not what you had in mind)
2. using Power Query. Import both lists into Power Query and combine them there. Power Query is available in all Excel versions since Excel 2016. And for Excel 2010 and 2013 you could download the free add-in from Microsoft
3. if you have Microsoft 365, you could use the new dynamic function VSTACK
