Remove delimiters in merged columns in power query when null
Maybe I am looking for the wrong keywords. I have merged several columns in power query with comma and space as the custom delimiters. Some of the source columns were blanks and the resulting merged column showed several commas and spaces. I tried clean and trim but the pesky commas and spaces remain. How do I remove those extra commas and spaces?
Thank you.
|