Removing duplicate values from a single row

[andy421]

I have an email column which has data like

email

abc@xyz.com

pqr@xyz.com

abc@xyz.com,abc@xyz.com,abc@xyz.com

abc@xyz.com

pqr@xyz.com,pqr@xyz.com

I need to keep only 1 email in the row

Expected output

email

abc@xyz.com

pqr@xyz.com

abc@xyz.com

abc@xyz.com

pqr@xyz.com

How to go about this in power query.

I tried to extract data and keep contents before .com but having trouble with syntax of Text.Combine to add .com back within the same column in the power query steps

[jennratten · Accepted solution]

Hello - you can get the expected result by extracting the text before the comma, like this:

Table.TransformColumns(#"Changed Type", {{"Column1", each Text.BeforeDelimiter(_, ","), type text}})

Result