Hi. I have merged five columns by power query in both add column and transform tab. Some of the cells have null values and the result was like:
Abc;;klm;;
Any idea on how to remove the extra delimeters in the PQ?
Thank you.