The attempt to combine wisdom and power has only rarely been successful and then only for a short while.
IN THIS CHAPTER, YOU WILL
Append tables from a few specified data sources
Append multiple Excel workbooks from a folder
Append multiple worksheets from an Excel workbook
While Albert Einstein’s quote may be correct, and wisdom and power have only rarely been combined successfully, with Power Query you have the power to combine multiple sources to gain a lasting wisdom. In this chapter you will learn how to combine multiple tables in various levels of complexity to gain insights from the combined datasets.