if else statement without creating new column

[AndrewPF]

I have a simple IF statement which corrects the value of "Group" for specific instances, for example: 

= Table.AddColumn(#"Previous Step", "New Group", each
     if [Name] = "Batman" then "DC"
else if [Name] = "Wonder Woman" then "DC"
else if [Name] = "Iron Man" then "Marvel"
else if [Name] = "Goofy" then "Disney"
else if [Name] = "Mickey Mouse" then "Disney"
else [Group])

but the only way I have found of doing this is to create a new column - "New Group". 

Is there any way of altering this code so that I alter the value of "Group" instead of adding the new column "New Group"? 

[Pragati11 · Accepted solution]

Hi @AndrewPF ,

You can try multile replace statements on the Group column rather than trying to create a new column.

You can follow this trick here for creating multiple replacement staements as a SINGLE statement in Power Query:

https://www.youtube.com/watch?v=cOXNbaa_02U