Thread: Remove extra delimiters in power query from merged columns with null values
View Single Post
 
Old 02-16-2021, 09:48 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Quote:
Originally Posted by p45cal View Post
There are probably better/more elegant ways!
eg. with:

Code:
Result = Table.AddColumn(PreviousStep, "Custom", each Text.Combine(List.Select({[Hdr1],[Hdr2],[Hdr3],[Hdr4],[Hdr5],[Hdr6]}, each _<> "" and _ <> null),";"))
Reply With Quote