Forum Discussion
Solved
Edit Cell values in power Query
This may be a dumb question but how do I edit cell values in a column in Power Query?
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.
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?
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.
