so I have 2 sheets and need to create a third one as follows:
Sheet1
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Sheet2
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
I need sheet3 to be created as:
ID ID_2 Data
Many thanks in advance.
Sheet1
ID | Name | Code |
A001 | A | C1 |
A002 | B | C2 |
A003 | C | C3 |
A004 | D | C4 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Sheet2
Code | ID_2 | Data |
C1 | B001 | 2 |
C1 | B002 | 3 |
C1 | B003 | 4 |
C1 | B004 | 3 |
C1 | B005 | 2 |
C2 | B006 | 1 |
C2 | B007 | 2 |
C3 | B008 | 2 |
C3 | B009 | 2 |
C3 | B010 | 5 |
C4 | B011 | 4 |
C4 | B012 | 6 |
C4 | B013 | 2 |
C4 | B014 | 1 |
C4 | B015 | 2 |
C4 | B016 | 3 |
C4 | B017 | 5 |
C4 | B018 | 5 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
I need sheet3 to be created as:
ID ID_2 Data
Many thanks in advance.