MarkCBB
Active Member
- Joined
- Apr 12, 2010
- Messages
- 497
Hi There,
How would I go about replacing a value in one column based on a value in another column, i.e. in column A I have 1,2,3,4,5 and in Column B I have a,b,c,d,e. If the value of column B = c then I want to replace 3 with dog.
Is this possible? How would I do this in Power Query?
How would I go about replacing a value in one column based on a value in another column, i.e. in column A I have 1,2,3,4,5 and in Column B I have a,b,c,d,e. If the value of column B = c then I want to replace 3 with dog.
Is this possible? How would I do this in Power Query?
