I have copy pasted some name, desig and email data from a website, after pasting realized that the first middle and last name is in 3 rows. Desig and email ID is in corresponding column to that of name.

What I want? I want to merge complete name in one row without disturbing the corresponding design and email column

Challenge ?

Some names are in 2 rows, some are in 3 rows.

The data is about 15k so require some formula to accomplish what I want.

Can someone help?