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?
#1
mmbr1606
9
Super User 2025 Season 1
#2
stampcoin
7
#3
SD-13050734-0
6
Share
Report
All responses (
Answers (
