Quick LinksSplit Cells by Delimiter to Isolate ValuesReplace Errors for Use in CalculationsUnpivot Data to Aid AnalysisFill Blank Cells Based on the Cell Above (Or Below)Have you heard of Power Query ...

All details in this article are correct as of 30 June 2025. Accessibility to some of the latest Excel features depends on ...

This article shows how Microsoft Power Query for Excel can streamline the ongoing delivery of additional data for analysis by PivotTables.

Master advanced filtering techniques in Excel & Power Query to transform data, extract insights, and streamline your analysis process.

Use Excel’s “Get Data from Folder” feature to import and combine multiple trial balance files into a single query. Clean and transform data using Power Query to prepare it for analysis.

Excel’s new Get Data preview improves Power Query with a modern layout, search, and OneLake catalog access in Version 2505.

The above query, when SelectSingleNode from any child, always returns null (no match).

Unlock the potential of Power Query in Excel and achieve automatic data updates. Follow our guide for seamless integration ...

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

Learn how to work around a couple bugs in Excel to return double values; drill down on lists with anonymous types; and learn the difference between Build and Rebuild.