Hi Team,
I have 2 reports with different data and want to merge the reports. I can understand that with 'contains' formula we can get the result. However, for large data set contains formula will not be feasible. Please let me know if there is any other approach for the same.
Report 1:
| Description |
| ABC USA |
| ABC France |
| ABC CanadaLtd |
| ABC Canada |
| ABC Australia |
| ABC Brazil |
Report 2:
| Country |
| USA |
| Australia |
| Canada |
| Netherlands |
Output:
| Country | Description |
| USA | ABC USA |
| Australia | ABC Australia |
| Canada | ABC CanadaLtd |
| Canada | ABC Canada |
| Netherlands | NIL |
Regards,
Shikha
