How to Merge Cells in Excel On top of making a sheet’s layout look clean, combining cells can also help group related data. That way, you don’t have to stretch cells to show more information.

If your source data is in Excel and has duplicates, run Power Query to remove those duplicates before running a Word mail merge.

Data comes from all kinds of sources and Microsoft Power Query can you when you need to combine foreign data. It’s a bit easier than trying to do so in Microsoft Excel sometimes.