If you've never heard of Excel's Power Query feature, you're not alone. Here's how to get started using it and gain a huge productivity boost.

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.

Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.

The Get & Transform in Excel and the Power Query add-in include some new or improved Data Transformation features, as well. How to use Get and Transform feature in Excel ...