Transpose multiple rows to one column keping the row header.

So, I have many lists of emails and I need to create one list that has each email address (and only the email address) in a column with the email group specified on the left.

Gonna have to do this on a periodic basis with large amounts of data starting... well... earlier today... so any help will be much appreciated!

What I get, what I ended up with after text to columns & some text chopping, and what I actually need is in the file attached.

Thanks!