Merge Data

4 lessons in order

Learn how to merge rows with the same value in Excel using Merge & Center, TEXTJOIN, Power Query, Consolidate, Subtotal, and VBA macros.

Learn how to combine rows with the same ID in Excel using TEXTJOIN, Power Query, or Pivot Tables to summarize and organize your data.

Learn how to merge 3 columns in Excel using TEXTJOIN, CONCAT, Power Query, LET, and other efficient formulas and functions.

Learn how to merge two columns in Excel with a space using &, CONCAT, TEXTJOIN, and Flash Fill step-by-step examples for quick results.