Forum Discussion
Power Query from sharepoint list row shifting error
If I understand the issue, you cannot do this. The data coming from Power Query will not retain the same row number as manually entered data.
You will need to either put your manual data in another table with some sort of index that you can merge on - so "Item 1" for example.
Then in PQ, merge the SharePoint table with the Excel manual table and use your manually added column.
You can see more about merging here. Merge queries (Power Query) (microsoft.com)
If I understand the issue, you cannot do this. The data coming from Power Query will not retain the same row number as manually entered data.
You will need to either put your manual data in another table with some sort of index that you can merge on - so "Item 1" for example.
Then in PQ, merge the SharePoint table with the Excel manual table and use your manually added column.
You can see more about merging here. Merge queries (Power Query) (microsoft.com)
Ah, good catch edhans. After reading the post through a couple more times, I think you are dead on.