Here is my data
And this is what i want my data to look like:
Is this possible without manually doing it? data is over 1000 rows long.
External first name | external last name | relationship | Internal name |
John | Smith | leader | Sara Jones |
John | Smith | leader | Jennifer Smith |
Bob | Brown | leader | David Chan |
Michelle | Adam | leader | Noel David |
Michelle | Adam | leader | Allen Stevens |
Michelle | Adam | leader | Jordan Wood |
Michelle | Adam | leader | Erin May |
Michelle | Adam | leader | Karen Sinclair |
And this is what i want my data to look like:
External first name | external last name | relationship | Internal name |
John | Smith | leader | Sara Jones; Jennifer Smith |
Bob | Brown | leader | David Chan |
Michelle | Adam | leader | Noel David; Allen Stevens; Jordan Wood; Erin May; Karen Sinclair |
Is this possible without manually doing it? data is over 1000 rows long.