Hi Guys,
PLease help me out. I need a VBA code or any other solution to produce the following.
Basically, I have two datasets where the same information is stored for different countries, and I need to merge them into one quite often.
Dataset 1 example
<tbody>
</tbody>
For every row where there is no data there is a 0
Dataset 2 example
<tbody>
</tbody>
Exactly same headers and same data but for different set of countries
Consolidated Dataset (this is what I'm trying to automate)
<tbody>
</tbody>
Basically, I want to copy paste all data from 2 datasets, right after each other without taking into account 0's. Zeros are basically blanks
Please help!
Thanks. S
PLease help me out. I need a VBA code or any other solution to produce the following.
Basically, I have two datasets where the same information is stored for different countries, and I need to merge them into one quite often.
Dataset 1 example
A | B | C | D | |
1 | Country | Type | Sub-type | Amount |
2 | USA | Fruit | Apple | 3 |
3 | Canada | Fruit | Orange | 5 |
4 | Sweden | Vegetable | Tomato | 1 |
5 | Norway | fruit | Pear | 4 |
6 | 0 | 0 | 0 | 0 |
7 | 0 | 0 | 0 | 0 |
8 | 0 | 0 | 0 | 0 |
9 | 0 | 0 | 0 | 0 |
10 | 0 | 0 | 0 | 0 |
11 | 0 | 0 | 0 | 0 |
<tbody>
</tbody>
For every row where there is no data there is a 0
Dataset 2 example
A | B | C | D | |
1 | Country | Type | Sub-type | Amount |
2 | Azerbaijan | Vegetable | Cucumber | 4 |
3 | India | Fruit | Orange | 1 |
4 | Thailand | Vegetable | Tomato | 1 |
5 | Bangladesh | Fruit | Apple | 2 |
6 | 0 | 0 | 0 | 0 |
7 | 0 | 0 | 0 | 0 |
8 | 0 | 0 | 0 | 0 |
<tbody>
</tbody>
Exactly same headers and same data but for different set of countries
Consolidated Dataset (this is what I'm trying to automate)
A | B | C | D | |
1 | Country | Type | Sub-Type | Amount |
2 | USA | Fruit | Apple | 3 |
3 | Canada | Fruit | Orange | 5 |
4 | Sweden | Vegetable | Tomato | 1 |
5 | Norway | Fruit | Pear | 4 |
6 | Azerbaijan | Vegetable | Cucumber | 4 |
7 | India | Fruit | Orange | 1 |
8 | Thailand | VEgetable | Tomato | 1 |
9 | Bangladesh | Fruit | Apple | 2 |
<tbody>
</tbody>
Basically, I want to copy paste all data from 2 datasets, right after each other without taking into account 0's. Zeros are basically blanks
Please help!
Thanks. S