Forum Discussion
Solved
Power Query from sharepoint list row shifting error
I run a query in Excel to get data from a Sharepoint list. In the columns to the right of the sharepoint data in excel, I have manual entries that I need to remain linked with the same row through da...
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)
acmwib What does your Excel query look like?