3 Ways to Unstack Data in Power Query. Watch this video on YouTube. Here are more detailed guides and articles that you may find helpful on Power Query.

This guide discusses combining tables from the same workbook only, not external sources or multiple workbooks. Make sure all the datasets you want to append are formatted as Excel ...