Advanced Concatenate/ Merge columns with Power Query

Concatenating columns in Power Query is not hard to do, but depending on the technique you use, you might get unexpected or wrong results.

Table of contents:

00:00 Intro & Problem description
01:19 How power query concatenates columns with Table.CombineColumns
02:40 Issues with nulls when concatenating using a custom column
04:00 Explain Text.Combine function in power query
04:17 The final pattern/ solution
05:00 Avoid errors with nulls in the new pattern

Watch the tutorial:

Links to the mentioned resources

Link to the null, blank video mentioned in this video: