I have to combine datasets as per common fields/criteria into the same sheet. In my example (Record ID & Record ID type ) are common fields. I have attached input & output required tab for reference.
Input Tab :-
| Record ID - I | Record ID Type I | Sales% -A | Revenue %-A | Record ID - II | Record ID Type II | Sales%-B | Net Income %-B | Record ID - III | Record ID Type III | Revenue %-C | Net Income %-C |
| 10 | A1 | 8% | 8% | 10 | A1 | 6% | 8% | 20 | B2 | 8% | 8% |
| 20 | B2 | 5% | 6% | 20 | B2 | 8% | 6% | 30 | C3 | 6% | 6% |
| 30 | C3 | 2% | 7% | 30 | C3 | 4% | 7% | 40 | D4 | 7% | 7% |
| 40 | D4 | 1% | 5% | 40 | D4 | 2% | 5% | 50 | E5 | 5% | 5% |
| | | | | 50 | E5 | 8% | 8% | 60 | F6 | 5% | 8% |
| | | | | 60 | F6 | 5% | 5% | | | | |
| | | | | 70 | G7 | 2% | 2% | | | | |
| | | | | 80 | H8 | 1% | 6% | | | | |
| | | | | 90 | I9 | 1% | 7% | | | | |
Output Tab Required :-
| Record ID | Record ID Type | Sales% -A | Revenue %-A | Sales%-B | Net Income %-B | Revenue %-C | Net Income %-C |
| 10 | A1 | 8% | 8% | 6% | 8% | | |
| 20 | B2 | 5% | 6% | 8% | 6% | 8% | 8% |
| 30 | C3 | 2% | 7% | 4% | 7% | 6% | 6% |
| 40 | D4 | 1% | 5% | 2% | 5% | 7% | 7% |
| 50 | E5 | | | 8% | 8% | 5% | 5% |
| 60 | F6 | | | 5% | 5% | 5% | 8% |
| 70 | G7 | | | 2% | 2% | | |
| 80 | H8 | | | 1% | 6% | | |
| 90 | I9 | | | 1% | 7% | | |
