Organize Column A into multiple Columns

Hello all, first time poster here with what is (to me, at least) a conundrum. I have a spreadsheet with all of my data in Column A (the data came from an HTML file that was converted to a .txt file and then imported into Excel 2010).

There are subject headings within Column A, but they're all in the pattern of:
Row 1: Heading 1
Row 2: ------------------ [there are literally dashes in this cell]
Row 3 through 15: <data that needs to be in a different column>
Row 16: [empty cell]
Row 17: Heading 2
Row 18: ------------------ [again, dashes under each heading]
Row 19-27: <Data that needs to be in a different column>
Row 28: Heading 3...

And it continues. It's somewhat of a repeating pattern in that after several different Headings (I think 47?) you get back to Heading 1, and the whole thing repeats (but with different <Data that needs to be in a different column> each time).

What I'm looking for is some macro or VBA script or voodoo spell that will put everything that is currently between Heading 1 and Heading 2 into Column B, everything between Heading 2 and Heading 3 into Column C, etc... and do that for each occurrence of Heading 1, Heading 2, etc.

Is something like this even possible? Or am I simply in for a LOT of copying and pasting?

Thanks in advance for any help/insight you can offer.

(P.S. Sorry if this is in the wrong thread, but I'm not sure what I need exactly as a solution, so I stuck to the general forum.)

Do you have this already in a spreadsheet that could be downloaded?

Absolutely; sorry for the long wait, I had some errands to run. Here it is: Average CAW.xlsx

It's Sheet2 I'm looking at.

Try this. It works on mine. You can modify it easily.

Hi -

Use find method as below;

Please Login or Register  to view this content.

Regards,
Event