Remove extra delimiters in power query from merged columns with null values

		Microsoft Office Forums > Microsoft Excel > Excel
Remove extra delimiters in power query from merged columns with null values

FAQ

Thread Tools

Display Modes

02-16-2021, 09:48 AM

p45cal

Windows 10 Remove extra delimiters in power query from merged columns with null values

Office 2019

Expert

Join Date: Apr 2014

Posts: 962

Quote:

Originally Posted by p45cal

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),";"))

« Previous Thread | Next Thread »

Similar Threads
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
How to unmerge all merged cell and fill them with the merged values?	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
Display Null Values in Pivot as 0	lornalou	Excel	2	06-02-2016 10:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:18 PM.