Here is my data
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. Thanks.
Bookmarks