I have two Excel documents with AD user information that I need to merge to gather all information.
One of the documents has information about AD groups and the names of the members of these groups. The other document has information about the users - if they are enabled, username, name and e-mail address.
The common values in the documents are the names. I want the values of the users' usernames and e-mail addresses over in the Excel document with the groups.
I have more than 3400 rows in the groups document and 271 users listed in the users document. In the groups document the users will be listed several times, since a user can, and will be a member of more than one group.
Is there a way to merge the data I want (e-mail address and username) using the common value in both the documents (the users name)? And is there any problem with the users being listed several times?
I managed to do this by installing an addon to Excel, Ablebits Data.
It gave me the possibility to merge the excel documents and add data fra one to the other with reference to the data that was the same.