Power Query Merging Columns and M Code (managing nulls and excess delimiters)

In this video, I go deeper into the issue of clearing excessive delimiters after merging columns in Power Query (Get and Transform).

The previous, related video:

This video describes:
1. Why my hack worked.
I replaced nulls with: ^
Then systematically replaced the ^ symbols. This is much better that merging columns and having lots of delimiters stuck together

2. An M-code solution that Owen Auger helped me with, using
List.RemoveNulls
This is a single step and very clean. However, this solution is in the world of writing code and is great for those who are comfortable with coding.

Check out the previous video to see how this can be handled in native Excel by using the TEXTJOIN function.

Also mentioned in the video; other giants in the world of writing M-code:

Owen Auger
https://owenaugerblog.wordpress.com/
Miguel Escobar
https://www.poweredsolutions.co/blog/
Ken Puls
http://www.excelguru.ca/blog/
Bill Syzyz
https://www.youtube.com/channel/UCx_joCOEjU1KdTpPvu4baYA
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: http://datascopic.net/blog-2-2