Forum Discussion
Track Action items (Source file gets updated weekly)
Hello All, Hoping you can give me some options. I have an order list (xlsx) where action items are added to the file to track. The file changes weekly with new orders added. I created a connec...
That's only if you have unique ID:s for the records. The trick is to query again returned by it table from spreadsheet and merge with itself on ID. That will sync with manually added column. Expand it after the merging, you will have combined query.
Please note all above shall be done within one query, not as separate queries.
- SergeiBaklan - Thank you for taking the time to respond.
I'm pretty new to power query would you be able to expand on the detail above or link some examples? I will try this from my side this morning.
Thank you
