I have got 3 headers named [Added By], [Last Maint By] and [Closed By] on one spreadsheet. All 3 of these are actually employee ID's.
I then have another spreadsheet which has the header [Employees] which is also the employee ID. I want to map all 3 off those headers to this header so that I can pull back information on the employees who are opening and closing calls for example [Position] and [Team].
Can this be done at all using mapping loads and apply map?