![]() |
|
|
Thread Tools | Display Modes |
#1
|
||||
|
||||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Remove delimiters in merged columns in power query when null | Marcia | Excel | 2 | 11-06-2020 09:42 PM |
Power Query to combine multiple tables of unequal number of columns | ProudLiberal | Excel | 1 | 01-07-2020 07:54 PM |
![]() |
Bumba | Excel Programming | 1 | 11-10-2019 11:36 AM |
Query and Power Query not working Excel 2016 | bl10 | Excel | 0 | 07-22-2016 06:25 PM |
![]() |
lornalou | Excel | 2 | 06-02-2016 10:39 AM |