If you come across a table on the web or in another source that you want to import into Excel, there's an import feature that does the work for you.

SEE: Explore 6 ways to save time using Flash Fill in Microsoft Excel. How to use Power Query to parse data in Microsoft Excel Power Query is available to Microsoft Excel 2010 users and later.

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