@RaytheonXie-MSFT ,Do you mean this?
Sorry, i am poor in powersehll, my main purpose is to build sharepoint web-part , if you have other way to do this, thanks a lot.
@JanisGustaps-5273
Was this function you want ?
Create, view, and edit contacts and contact lists in Outlook.com
This url :5b909158-036e-4820-92f7-2a27f57b9f01
@JanisGustaps-5273 , you can try establish an excel an import to outlook like thiscreate-a-contact-group-or-distribution-list-in-outlook-for-pc-88ff6c60-0a1d-4b54-8c9d-9e1a71bc3023
If you want to do in progress , you should go to exchange admin center to do this create-edit-or-delete-a-security-group
I hope you have answered your question.
Dora
sorry, @VikiJi-MSFT I mean i have two data where in sharepoint list and excel ,however they are the same column. merge is not my hope . I mean i want them can merge to same one same column,can you help mw? thanks.
Thank you for your sharing.