I have ticket data in which i need all of the teams except the green team. Each ticket is listed multiple times because when the status changes it creates a new row of data. I need to return the data from every team except the green team. For example if I use the filter to only give me tickets from the red team I will lose many records as some of their names are blank when the rows get added. I also cannot just populate the rows with the team name because teams can change. Shown in the data on ticket number 3 it starts with the yellow team and ends with red team.
In the document I have the data and what the ideal outcome is in the next tab. Thank you!
