Microsoft Office Forums - View Single Post - Remove delimiters in merged columns in power query when null

Thread: Remove delimiters in merged columns in power query when null

View Single Post

Old

11-06-2020, 09:42 PM

Marcia

Marcia is offline

Marcia uses Windows 7 32bit

Windows 7 32bit Marcia uses Office 2013

Marcia uses Office 2013

Office 2013

Expert

The original poster

Join Date: May 2018

Location: Philippines

Posts: 527

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Default

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?

Reply With Quote