Convert a word document with different but grouped line responses to an excel/csv document? : I'm tried to convert ~4,000 user entries (ex. from a user database in MS word) to a workable excel/csv document. Each entry, if fully completed, would be in the following format:

State
Full Name
Email
Organization
Position

The entries I have are variations of the above format (meaning that not all the fields were entered). The 1st line is almost always the state, every entry has a full name, not all entries have emails, organization listed, or the position.

For instance the first page of data might look like the following (Each entry is separated by a blank line):
_________________________________________________________________

California
John Doe
johndoe@gmail.com

Jane Smith
janesmith@yahoo.com
Apple Inc.

Alabama
Mark Stein
markstein@hotmail.com
Yahoo Corporation
Data Manager
_______________________________________________________________________

How do I convert the following above entries (in microsoft word) to an excel doc/csv that would look like the following:
[Final Format in MS Excel][1]


  [1]: https://i.stack.imgur.com/7IBAT.png