Forum Discussion
Solved
Manually enter data in rows of excel table using Power Query
I have an excel table (say Table1) which is loaded using a power query. Table1 has data which looks like the following: Now I ran a query on table1 to add a blank row for each product, ...
The idea as in attached. But it depends on data logic. How to create the key and how to keep sorting depends on that.
That's to query table with manually added row and merge it with the query which returns data from external source. For that you need to have (or generate) , unique ID for each records in the table. Merging shall be within the query which load table into the grid.
You may goggle for self-referencing table. Usually that's about manually added columns, but with some modifications shall work for rows.
- Thank you for the help SergeiBaklan
I have tried using the internet and doing some experiments myself to find help but only found solutions for manually added columns as you mentioned. I would really appreciate your help with finding a solution for manually added rows.
Thank you.The idea as in attached. But it depends on data logic. How to create the key and how to keep sorting depends on that.
- SergeiBaklan
Could you please explain how is the query "Source_1" created?
Because as far as I understood, the data source for query "Source_1" is the resultant table of the query "Source". However "Source_1" is being used in the creation of query "Source". It's kind of like an interconnected loop which I am not able to understand.
I would be really grateful if you could you please help me out with this.
