Clean address column

[Robin96]

Hey all,

Is there a way to clean the customer address field? i have imported a CSV file. There are different ways the customer writes their addresses, here are some examples:

i want the address to be shown as: Streetname 99

[davehus · Accepted solution]

Hi @Robin96 ,

The first bit would be to try and standardise the incoming address from the customer if possible. You can use a conditional column in powerquery to work through your column and clean it into a new column but I don't know how intensive that might be in terms of the data etc based on your example.

Hope this helps.

Did I help you today? Please accept my solution and hit the Kudos button.

[Robin96]

Hey, @davehus 

Thanks for the reply. there is unfortunately no way to standardise the incoming data as its data from Shopify Checkout. Guess i'll have to shape the data somewhere else then the power query editor.