Hello,
I would like to combine Project Managers Names after splitting as you will see in sheet column Current Project Manager Name into group sheet and named sheet same as in column Owners Name after Combine
Example:
Combine Engineering Department – User + Mr Ahmed Mokhtar Ahmed Soliman =ENG Sheet