Replacing Column Values based on what it is

[jinweitan]

Hi all,

I have a question regarding potential to replace values of a column to another based on what it is.

For example:

I have a table of:

ID	Items
1	A
2	B
3	A
4	C

Where I want 

A = Apple

B = Orange

C = Mango

Replacing the Alphabet into items, end product having:

ID	Items
1	Apple
2	Orange
3	Apple
4	Mango

I know I can simply replacing A, B, C through clicking "Replacing Values", however imagine if it is A to Z where there are a lot of other values, are there any easier method to achieve this?

Is there anyway to do that?

Many thanks.

[amitchandak · Accepted solution]

@jinweitan , better to load them as a table and merge

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[Greg_Deckler]

@jinweitan - Sounds like you need a Merge query, Table.Join.