Excel Power Query makes transforming and cleaning up data a breeze. By using Conditional Columns and Excel Power Query Fill Command you'll transform nested data into a clean, useable list. Download the Exercise file to follow along: ExcelPowerQueryFeatures

I recently recorded a handful of videos for my Complete Microsoft Excel course and thought I would share these videos. I've placed them in a YouTube playlist to make is accessible in order to go through each. The videos include working with Excel's VLOOKUP, HLOOKUP and the INDEX and MATCH functions. MICROSOFT EXCEL LOOKUP FUNCTIONS PLAYLIST Please download the exercise file to follow along with the video: Excel103-AdvLOOKUPExercises.XLSX

TEXTJOIN() FUNCTION DEFINITION =TEXTJOIN(delimiter, ignore_empty, text_1, [text_2], [text_3], …) BENEFITS The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges. Download the exercise file used in the video to follow along: ExcelTextJoinFunction-01.XLSX

I recently got a question about cleaning up a list of addresses in order to make it useable for a mail merge. The original data looks something like this. It's a pretty simple list of addresses. But, not very useable. The data is in two columns and organized into address blocks. What happens if you want to sort the data by last name, or perform a filter on Region? The data needs to be organized into a list. Something like this... You've got a couple of options... You can spen