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
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:
My book: Guerrilla Data Analysis 2nd Edition
My old blog: http://datascopic.net/blog-2-2