adding new values to a new field based off previous field in same layer (query)

Question

I have a layer, I am trying to merge multiple values (multi family, multi family <10) from field 1 into a newly created field 2 as the same value (MF). I have over 50,000 records of this so I was wondering if im in an edit session will the attribute query work for this? Haven't had much luck so far. or maybe another tool will execute this.

field 1 has multi family and multi family < 10 (along with 50 other value types)

field is currently all NULL.

I want so select the values from field 1 that are  multi family and multi family <10 and create a new value in field 2 as 'MF'.

Lake_Worth_BeachAdmin · Answer

Thanks this was the method I actually used for my needs for this specific request! Definitely saved me a lot of time!

Lake_Worth_BeachAdmin · Answer

Sweet thank you for the answer, this method works perfectly for my needs.

JoshuaBixby · Answer

Open the field calculator on field2 and paste the following in the field calculator expression block (replace field1 with the actual field name): 'MF' if !field1! in ('multi family', 'multi family < 10') else None‍