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