I have the following sheets: Sheet1
Code M P Z
11
14
13
6
19
14
17
1
12
7
Sheet 2
Code A B C
12 1 2 3
14 1 4 3
7 2 2 2
11 6 5 2
6 3 3 2
12 1 2 3
I want to get this table in sheet 1
Code M P Z
11 6 5 2
14 1 4 3
13 NA NA NA
6 3 3 2
19 NA NA NA
14 1 4 3
17 NA NA NA
1 NA NA NA
12 1 2 3
7 2 2 2
I want to move data from sheet 2 to sheet1 using only codes. Thank you for your help
