I have two inputs:
Input A
| Country | Fruits | Amount |
| USA | Apple | 500 |
| USA | Orange | 600 |
| India | Banana | 700 |
| New Zealand | Kiwi | 800 |
| India | Mango | 900 |
| Pakistan | Pineapple | 1000 |
Input B
| A1 | B1 | C1 |
| USA | Created by | Alex |
| USA | Posted by | Lia |
| USA | Reviewed by | John |
I want to out Input A and B , side-by-side, to different tabs based on Country in common.
So, For example, in my output file, i would have a tab named "USA", with below as my output:
| Country | Fruits | Amount | B1 | C1 |
| USA | Apple | 500 | Created by | Alex |
| USA | Orange | 600 | Posted by | Lia |
| | | | Reviewed by | John |
How can I get this?