Forum Discussion

Ful56's avatar
Ful56
Regular Visitor
3 years ago

Adding a blank column & retaining data

Hi    I have a attendance excel document which I'm getting data from a third party source but I want to add a notes column so they can add notes against a student.  problem is I cant do this i...
Need Help
AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
3 years ago

Hi Ful56 it's possible if you have or create unique key. You'll need to load PQ data to the sheet, add column for comments, load table back to PQ and merge original query with the last one using unique key. Well known self referencing queries/tables. Check this out.