Forum Discussion
how to edit cell value directly in query editor?
Hi Phoebe_Zhang
Drag and extend formula to all cell is not possible with Power Query. What you can try is to use "Column from Example". It will automatically create formula required based on sample values. Keep in mind it will require 3-4 sample values to provide the expected result.
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.
Hello Phoebe_Zhang
as I already mentioned, in my oppinion there is no way to do this in the editor. You can create both column manualy. But adding data on a existing query won't work. What if the sort order of the data query is changing? If you would use Excel as working platform, there would be a way to do something like this on a spreadsheet, bot no on power query.
Jimmy
thans, i think i got the solution~~thank you very much~