Merge Columns in Power Query
February 27, 2023 - by Bill Jelen

Problem: I have first name in column A and last name in column B. I would like to concatenate those names and convert to proper case.
Strategy: Use Merge Columns in Power Query.
Select all of the columns that you want to merge. From the Add Column tab in the Power Query ribbon, choose Merge Columns.

The Merge dialog offers various separators to use between the colums: None, Colon, Comma, Equals Sign, Semi-colon, Space, Tab, or Custom.
Choose Space from the Delimiter drop-down menu. The default name for the new column is Merged. Type a meaningful name such as Name.

To convert the results to proper case, go to the Transform tab in the Power Query ribbon. Open the Format drop-down menu and choose Capitalize Each Word.

This article is an excerpt from Power Excel With MrExcel
Title photo by Nil Castellví on Unsplash