Replace values

[Angie_]

Hi,

I have a list with the request updated manually by human or system as per below (Table 1) and i would like to replace those human name with Manual and remain the System as System like (Table 2). May I know how to transform it?

Table 1

Request #	Updated by
1	Dave
2	Ken
3	System
4	Dana
5	Sandy
6	Amanda
7	Vivian
8	System
9	Sandy
10	Ken

Table 2

Request #	Updated by
1	Manual
2	Manual
3	System
4	Manual
5	Manual
6	Manual
7	Manual
8	System
9	Manual
10	Manual

Thank you.

[ryan_mayu · Accepted solution]

@Angie_ 

Column = if('Table'[updated by]="System","System","Mannual")

or in Pq

if [updated by]="System" then "System" else "Mannual"

then remove the updated by column