Forum Discussion
Can I add data (new row) to a Custom-Created Table?
Hi Anonymous
If you click on Transform Data and go to Power Query, you should be able to click the "Enter Data" button on the "Home" tab of the Ribbon.
Once you do that, it will create a new table. Just add the matching details and then Append the two tables together in Power Query.
Hope this helps 🙂
Theo
In the Applied Steps pane on the right, click the gear icon on the first step.
This opens back up the Enter Data grid you pasted data into.
If you don't see this pane on the right of the query editor window, then you need to enable it under the View tab of the ribbon:
Super UserIn the Applied Steps pane on the right, click the gear icon on the first step.
This opens back up the Enter Data grid you pasted data into.
If you don't see this pane on the right of the query editor window, then you need to enable it under the View tab of the ribbon:
THIS helps SO much - thank yoU!!
- AlexisOlson
You're welcome! Please consider accepting this solution too if it resolves your question.
- TheoC
Community Champion
Anonymous this is the solution you want to run with 🙂
new user here, so apologies: how do I get to the Applied Steps pane to do this? I can't find it.
- AlexisOlson
Does this help?
https://learn.microsoft.com/en-us/power-query/applied-steps
Super useful, thank you!
