Highlighting or even deleting duplicate records in Excel is simple but listing them isn't as easy. Fortunately, you can use Power Query to easily display a list of duplicate values or records.

However, by using Excel’s Power Query, you can automate these processes, allowing single-click updates for your financial reports.

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

Data Loading: Begin by loading your tables into Power Query. Select the desired data range and choose ‘From Table/Range’ in the Power Query Editor.