So I have a data set with Employees, some other information, and then a column for Recipients. The Recipients column contains 2 charities separated by a comma, the task is to create a new dataset that has each charaity in its own row, so there would be two lines for each Employee ID, one for their first charity, one for their second. I can't figure out how to do this. Any insight?
... View more
