We show the basic syntax for SQL’s concatenate function CONCAT, with examples on how to combine with other SQL functions such as SELECT, DISTINCT, and calculations. Worked example also shows how to create a temporary table.
How to concatenate in Power Query, combining text columns, and text with data columns. Steps in how to import data and enter formulas in Power Query.
Look up values in a table, using Excel’s VLOOKUP with the CONCATENATE function to combine values in multiple cells for the lookup. For example, convert a long format data table to a wide format data table.