Managing duplicate names with PQ

Power Query
1

I have read Brian’s entry on the Analyst hub about dealing with entries with same names and find this rather useful for what I am looking at and I like the relative ease it can be achieved with DAX. However, as I have seen a few times the adage of, if it can be done in PQ, then ‘best do it there’ so I am wondering if someone could help out with showing how this can be achieved in PQ.

Like a few I am trying to expand knowledge of M to achieve things where possible. I have used one of the practise data files to plant a few duplicates in to a customer list to see how this can be achieved in PQ.

Duplicate names.xlsx (30.1 KB)

2

Hi @David,

Give this a go.
It uses the M Character.FromNumber function to add a Unicode Zero-Width Space character.

I hope this is helpful.

Duplicate names.xlsx (155.3 KB)

2 Likes
3

Melissa,

Perfect, many thanks!