I have two lists in SharePoint Online:
1. List1["https://siteName.sharepoint.com/sites/Test1"] (Importing items form excel) Fields: Name,Contact,Email 2. List2["https://siteName.sharepoint.com/"] Fields: Name,Contact,Email 3. List3["https://siteName.sharepoint.com/sites/Test3"] Fields: Name,Contact,Email List1 and List2 have list-items and List3 has only fields My requirement is that I want to merge List1 and List2 in List3. For example, In List1 - 10 items and in List2 - 30 items then I need 40 items in List3
How can i achieve this?
Thanks in advance.