I have two data tabs for survey responses - the first shows the full set of exepcted responses an which office they are from
HMIP LDU 1 Leeds 2 Leeds 3 Leeds 4 Leeds 5 Wakefield
The second those that have actually responded and I need to get their office location next to the ID:
HMIPID WYLDU 1 2 3 5
I have hundreds and will be doing this a lot so any help appreciated!