Edit Cell values in power Query

[bdehning]

This may be a dumb question but how do I edit cell values in a column in Power Query?  

[Ahmedx]

Can you please share your demo input and expected output!

[bdehning · Accepted solution]

I get it. I need to create a new Table and then enter my data and then merge that that column in to existing main table.  

[SanderVeeken]

Presumably, the information on what you want to change the values to is already somewhere in the data? Otherwise, is there a way to bring it in? Then you could keep the whole thing automated instead of manually updating your merge-table every time something changes in the source data. 

[Ahmedx]

[bdehning]

The problem is that I have allot of cells with the same numbers that I want to replace with different values.  Is there a place to edit row values one at a time?  

[SanderVeeken]

No, that's not possible and goes against the entire philosophy/mode of operation of a data transform operation. What happens if your data gets rows added later? You have to devise a process that always works.

If it's too complicated for PowerQuery you could always use a Python step, though that severely limits your publishing options.