Clay Icon

Merging Rows for Schools with Same Director in Excel or Google Sheets

·
·

Hello guys - I’ve a list of schools with their directors But sometimes I’ve 2 schools that are almost the same (collèges and lycée for those who know french system) with the same director, and I would like to keep the infos on the two lines without loosing any informations. How can I merge the rows like that ?