I have a census spreadsheet where an employee's name is listed on multiple lines. Each line represents a different line of coverage they are enrolled in. I am trying to turn each line of coverage into it's own column so each employee only has one line. I have attached an example with coordinating colors for where I am wanting the data to go. I am not sure what formula/function is going to work best to accomplish this. Please help!
