Question

You import an employee table into Power Query that contains separate FirstName and LastName columns. The business wants a single FullName column formatted as 'LastName, FirstName' (for example, 'Smith, Anna'), while keeping the original two columns intact for other reports. Which Power Query approach produces the required result with the least manual effort?

Accepted Answer

Add a custom column with the formula = [LastName] & ", " & [FirstName].

Answer

Select both columns and use Merge Columns with a custom separator of ', ', accepting the default column order.

Answer

Select both columns and use Format > Combine, then reverse the values with Split Column.

Answer

Use Group By on LastName and add an aggregated column that concatenates FirstName.