Looks like: ed_id emp_id general_data 100 1201 Commenced on 29/01/2011 and 101 1201 reports to John Smith in 102 1201 comms section 103 1202 New starter arriving on 1st 104 1202 June 2012
Target table to be:
emp_id general_data
And look like: emp_id general_data 1201 Commenced on 29/01/2011 and reports to John Smith in comms section 1202 New starter arriving on 1st June 2012
Can't seem to find a merge tool that will do it in one go. Source table has 16K rows Cheers!