unpivot column

Hello! I am trying to organize project data.. The data contains project list with the divisions (multiple divisions separated by semicolon) and departments who has worked on it. It also have a colum...