This video will show you how to create a Power Query reports from your source data. It will separate the file types based on using a delimeter.
In this lesson I will show you how to merge two tables. The first table contains Purchase Order numbers. The second table contains the invoice numbers that were applied to the original purchase orders.
The Power Query feature has a very cool feature called Split Columns. In this example I'll show you how to split your data into columns and rows based off the comma delimiter.
If you are new to Excel and are struggling to understand the basics let me share with you a downloadable guide that will help. Access your Excel Quick Start Guide here.