Hi,
I have difference info from Sheet1 & Sheet2 and I need to combine them into Sheet3.
<tbody>
</tbody><colgroup><col span="4"><col></colgroup>
<tbody>
</tbody><colgroup><col><col></colgroup>
Hope someone can help me.
Thanks in advance for the helps
I have difference info from Sheet1 & Sheet2 and I need to combine them into Sheet3.
sheet1 | sheet2 | |||
Item | Reading | Item | Name | |
A | 10 | A | China | |
A | 70 | A | Hong Kong | |
A | 51 | A | Taiwan | |
A | 45 | A | Australia | |
B | 12 | B | Korea | |
B | 11 | B | USA | |
B | 48 | B | Japan | |
C | 142 | C | Iceland | |
C | 21 | C | England | |
C | 77 | C | Thailand | |
C | 9 | C | Norway | |
C | 64 | C | India |
<tbody>
</tbody><colgroup><col span="4"><col></colgroup>
sheet3 | |
Name | Reading |
China | 10 |
China | 70 |
China | 51 |
China | 45 |
Hong Kong | 10 |
Hong Kong | 70 |
Hong Kong | 51 |
Hong Kong | 45 |
Taiwan | 10 |
Taiwan | 70 |
Taiwan | 51 |
Taiwan | 45 |
Australia | 10 |
Australia | 70 |
Australia | 51 |
Australia | 45 |
Korea | 12 |
Korea | 11 |
Korea | 48 |
USA | 12 |
USA | 11 |
USA | 48 |
Japan | 12 |
Japan | 11 |
Japan | 48 |
Iceland | 142 |
Iceland | 21 |
Iceland | 77 |
Iceland | 9 |
Iceland | 64 |
England | 142 |
England | 21 |
England | 77 |
England | 9 |
England | 64 |
Thailand | 142 |
Thailand | 21 |
Thailand | 77 |
Thailand | 9 |
Thailand | 64 |
Norway | 142 |
Norway | 21 |
Norway | 77 |
Norway | 9 |
Norway | 64 |
India | 142 |
India | 21 |
India | 77 |
India | 9 |
India | 64 |
<tbody>
</tbody><colgroup><col><col></colgroup>
Hope someone can help me.
Thanks in advance for the helps