I have a single column with thousands of rows of name and address information that I want to convert so that each new row contains all the information for a single person in multiple columns. Some people have 8 rows of information and some have more. The only consistent factor I can find is that the last row for each person contains their email address so can I separate them by looking for the @?

Thanks in advance. I am very much a beginner.