Table.CombineColumns
Table.CombineColumns is a function that merges multiple columns into one by using a combiner function. This results in the creation of a new column. It is important to note that Table.CombineColumns w...
Table.CombineColumns(table as table, sourceColumns as list, combiner as function, column as text) as tableTable.CombineColumns is a function that merges multiple columns into one by using a combiner function. This results in the creation of a new column. It is important to note that Table.CombineColumns works in the opposite way to Table.SplitColumn.
To combine the first and last names into a single column with a comma separator, you can use the Power Query MTable.CombineColumns function. In this function, you provide the table containing the names, specify the columns to combine (in this case, "LastName" and "FirstName"), define the delimiter (comma), and indicate the quote style. The output will be a new table with the combined names in a column named "FullName."