#1
|
||||
|
||||
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. |
#2
|
|||
|
|||
can you upload an example we can play with?
|
#3
|
||||
|
||||
I just found out that the commas appear in blank, not null cells. How do we force query to treat all blank cells as null?
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Format numbers in Power Query | Marcia | Excel | 2 | 09-21-2020 12:59 AM |
Power Query to combine multiple tables of unequal number of columns | ProudLiberal | Excel | 1 | 01-07-2020 07:54 PM |
Do I need a power query for this one? | shabbaranks | Excel | 5 | 04-10-2019 03:29 AM |
Issues Using Power Query file in Excel 2016 and then in 2013 | bld9936 | Excel Programming | 0 | 02-27-2017 12:50 PM |
Query and Power Query not working Excel 2016 | bl10 | Excel | 0 | 07-22-2016 06:25 PM |