Power Query

AJacobsPE

New Member
Joined
Feb 9, 2020
Messages
2
Office Version
365, 2019, 2016
Platform
Windows, MacOS
I am using power query to import data (student ID, name and attendance data) and want to be able to add comments in to subsequent cells in the row. Sometimes students are added to or removed from roll so I want the data in the row to move or be removed with the ID. Is this possible? Apologies if this is not clear.
 

AJacobsPE

New Member
Joined
Feb 9, 2020
Messages
2
Office Version
365, 2019, 2016
Platform
Windows, MacOS
Thanks, i've managed to set up the self-referencing tables, but some of the cells contain formulas that I want to retain, is there something I am missing to do this?
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
4,188
formulas in sources will stay
query tables doesn't contain any formulas
 

Forum statistics

Threads
1,085,181
Messages
5,382,167
Members
401,779
Latest member
Thonor

Some videos you may like

This Week's Hot Topics

Top