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...

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. I...

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 addres...