How to do data Cleansing for the below kind of data in Alteryx

[Tharashasank]

Hi Experts,

I have a situation where iam getting the below data from a data source. i want to clean the data and populate it as good data. Please suggest me how we can handle this in alteryx.

obj id	address	address2		region	state	country
1	Nyherji	Kÿ¿ÿ¶llunarklettsvegur 2	NULL	Reykjavik	NULL	Iceland
2	CANADIAN NORTH	3731 â¿¿ 52 Avenue East	NULL	Edmonton	Alberta	Canada
3	Atotech Deutschland GmbH	Erasmusstraÿ¿e 20	NULL	Berlin	NULL	Germany
4	PT. NTT Indonesia	Tower  WISMA 46 â¿¿ KOTA BNI 5TH FLOOR	NULL	jakarta pusat	NULL	Indonesia
5	BELL TECHNOLOGIES	Carrera 7 No, 155 c â¿¿ 20 PISO 25	NULL	Bogota	NULL	Colombia
6	Tauron Dystrybucja	ul. Dajwÿ¿ÿ³r 27	NULL	Krakÿ¿ÿ³w	NULL	Poland
7	Tauron Dystrybucja	ul. Dajwÿ¿ÿ¿ÿ¿ÿ³r 27	NULL	Krakÿ¿ÿ¿ÿ¿ÿ³w	NULL	Poland
8	Tauron Dystrybucja	ul. Dajwÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ³r 27	NULL	Krakÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ³w	NULL	Poland
9	Tauron Dystrybucja	ul. Dajwÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ³r 27	NULL	Krakÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ¿ÿ³w	NULL	Poland
10	Centrum Medyczne Puÿ¿awska Sp. z o.o.	ul. Puÿ¿awska 49	NULL	Piaseczno	NULL	Poland

[Inactive User]

Transpose into Rows grouping on Object ID. Then use formula tool and replace special characters with desired characters.