Power Query for Excel: Combine multiple files of different file types

Guest Post by Miguel Escobar - Twitter | Youtube | Blog | Website Power Query Magic:  The Ultimate and easiest way to consolidate multiple tables, sheets, text and/or csv files(Click for Full-Size Version) At some point in the life of an Excel user, we have all faced a similar dillemma. How can I combine multiple […]