Forum Discussion
How to combine a query table with columns in excel
I am trying to link a MS Query table with a 'notes' column in excel. The 'notes' column is not linked to the table so every time the data is refreshed the notes are out of alignment. Much time is spent realigning them. Is there a faster way to keep the notes in alignment with the query table?
1 Reply
Hi sblake
There might be a way using Power Query but it isn't straightforward. Matt Allington at exceleratorbi did a blog on it here.
https://exceleratorbi.com.au/self-referencing-tables-power-query/
If you have a unique ID or referenc for each record then I would recommend you set up a separate comments table and then use VLOOKUP or INDEXMATCH to pull that comment back into your main table.
