Forum Discussion
edit data in editqueries
In general, editing data in "Edit Queries" is done by using the rich library of Power Query functions and other Power Query language components, e.g. adding columns, replacing values etcetera.
If you really want to edit your data, it can only be done by creating a copy of your table and paste it in "Enter Data". There you can edit the data, but the copy will not be dynamically updated with any changes in the csv files.
My suggestion would be to edit the csv files (or use the rich library..... etcetera).
Here is a video that illustrates how to copy and edit data using "Enter Data":
In general, editing data in "Edit Queries" is done by using the rich library of Power Query functions and other Power Query language components, e.g. adding columns, replacing values etcetera.
If you really want to edit your data, it can only be done by creating a copy of your table and paste it in "Enter Data". There you can edit the data, but the copy will not be dynamically updated with any changes in the csv files.
My suggestion would be to edit the csv files (or use the rich library..... etcetera).
Here is a video that illustrates how to copy and edit data using "Enter Data":
tq guys for your help. Really appreciate:smileywink: