Forum Discussion
Alirezam
Helper V
6 years agoReplacing multiple valuse in Query
Hi mates, I have 2 tables. I want to replace one column's values with the second table. According to the photo attached, I want to replace 1 with a, 2 with b, 3 with c, so on. I know I can do it wi...
vivran22
Community Champion
6 years agoHelloAlirezam
What is the structure of table 2?
Col 1: Half Hour (with values from 1 to 26) & Col 2: Letters (with values from a to z)?
If this is so, then you can use Merge Queries option in Power Query
Regards,
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/