Yes you're both close to the mark now!

To clarify further. Tables A and C exist, table B we created to clarify the situation, i.e. how many users are assigned to...

It's quite straight forward actually. Based on the sample I gave, 4 of the users are assigned to Dept 1. In the new structure 2 of these 4 are assigned...

Hi Kenneth/ David,

thanks for your prompt replies.

David, to clarify things, this is a one off operation to try and automate the mapping process. All unmapped departments will be manually...