Forum Discussion
AdministratorCombining power query with manual data entry
Hi lloyda5,
You could create a new table by entering data in Power Query.
Or create the data in another tool, such as Excel, and import it into Power Query.
In your case, Merge Queries may be more suitable.
Below is an example.
Sample data:
Now suppose you need to add a column about student grades. This is where you can merge the table about student grades with your main table, and the matching column is your student name.
Student grades:
Merge:
Expand it.
Merge queries overview - Power Query | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AdministratorThanks for your reply. But where do you do the manual data entry? In the separate table you create, or in the combined table you have merged it with using PQ?
Community ChampionSyndicate_Admin in separate table insert amount, then import it via PQ and last step merge it with rest of other tables.