There are other ways to combine values into a single cell, but Power Query’s Columns From Examples feature is a breeze. ... but you can use the concatenation operator & and the TEXTJOIN() function.