Excel's Power Query Editor, with the Split Column option selected, and By Delimited highlighted. The Split Column By Delimited dialog box in Excel's Power Query, with 'Semicolon' and 'Rows' selected.

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.

Power Query for Excel 365 for Macs is being developed. These users are able to refresh queries but do not yet have the ability to author them in the Power Query Editor. The content of this article is ...

Power Query, otherwise known as Get & Transform, is available in earlier ribbon versions, but you need to install it as an add-in. There’s no comparable tool in earlier menu versions.