Curbal has its own social media server on Mastodon. Check it out here!
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

Print

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:

Advanced Concatenate/ Merge columns with Power Query

Links to the mentioned resources

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

If ISBLANK, NULL or EMPTY in power query
Was this helpful?

Reader Interactions

Let us know your thoughts...

Table of Contents