SQL CONCATENATE CONCAT
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.
CONCATENATE
Power Query concatenate text and numeric data
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.
VLOOKUP with CONCATENATE in Excel
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.