You’re offline. This is a read only version of the page.
2
I work in education and my team has a master spreadsheet with thousands of students on it. I manage a subsection of these students and want to be able to record a lot of information which is only needed for this particular subsection - this would clog up the master spreadsheet for a relatively small cohort of students so it's not going to be appropriate to add all the fields I need to the master.
I created a power query to pull my subsection of students into another spreadsheet, but I now want to be able to manually add additional information to the new spreadsheet. For example, I'll want a column to track when I've enrolled the student in our virtual learning environment, and this will just be a case of me inputting 'Y' for each student as and when they've been enrolled.
I tried simply adding additional columns to the table and that works fine until I refresh the data, and then the columns I've entered manually don't get sorted along with the data that's been pulled from the master.
Is there another way to do this?
Thanks for your reply. But where do you do the manual data entry? In the separate table you create, or in the combined table you have merged it with using PQ?
Share
Report
All responses (
Answers (
