Removing and Repeat Value

[dhakim1996]

Hi, I need some assistance in doing the following

Raw Data:

NAME OF X: ABC	Field1	Field2	Field3
	XX	XX	XX
	XX	XX	XX
	XX	XX	XX

Cleansed Data:

ABC	Field1	Field2	Field3
ABC	XX	XX	XX
ABC	XX	XX	XX
ABC	XX	XX	XX

Can anyone kindly assist please :)

Thank you. 

[Felipe_Ribeir0 · Accepted solution]

Hi @dhakim1996 

One way of doing this