Hey guys!

I have a set of data in column A that is about 6000 cells long. It contains name, email address, and a "chapter (I thought I could use this as a unique identifier), set up like this:

Name
Email Address
Chapter: *Los Angeles* <- example

Problem is that when the data was imported the email addresses were weird and went into multiple rows. So the data I have looks like this:

Doe, John
john.doe(AT)
mail(dot)com
Chapter: JohnnyDoe
Doe, John
john.doe(AT)mail(dot)com
Chapter: JohnnyDoe

This goes on fairly randomly for the rest of the data. I need a way to get the data into a format like this for a CSV file:

Name / Email / Chapter
Name / Email / Chapter
etc

The only thing I can find online is how to use the INDEX function for transposing data for a set number of lines, but my number changes constantly. Hopefully the "Chapter" identifier can help a little.

Thanks in advance!