Organizing groups data with inconsistent row count

Hello, I am not sure exactly how to put this into words so I was unable to search a solution.

I have a large list of items grouped into sections in a word document. I am trying to organize them into excel but am having trouble since the information is grouped in inconsistent sizes. I want to output them with the chapter next to the data so I can condense the information and easily sort/filter.

I am basically dumping the raw word doc data into one sheet as an input, and then on a second sheet trying to have it appear sorted.

example of how it appears when pasted into excel

and so on...

I want to list the Chapter next to each item like the example below