Merged Cells and multiple lines

[ATLGator]

I have a large spreadsheet that covers over 1,500 lines, but there are only 170-ish entries. The title of each entry (listed in Column A) is formatted by merging a varying number of rows and the objectives for each title are listed in another column, in the individual rows that make up the merged cells containing the title.

My goal is to create a new spreadsheet with one row per entry, which means combining the objectives for each title into one cell (I just need to get the information in there, I'll format them later). I already have the rest of the spreadsheet in individual rows, but now I need to combine the objectives. Is there any way to do this?

Thanks!

[royUK]

Merging cells is a really bad idea. You can't work with the data and cleaning up will be hard work.

You need to attach a small example workbook

[ATLGator]

The file was pulled from a data base and it was the only way the person knew how to pull the information - definitely not my choice.

Here is a sample file. It shows what I am working with and what I would like to turn it into. It doesn't need to be formatted the same way . . . I just need the information to be in the cell.