Need help 'cleaning up' a spreadsheet
 

I have a spreadsheet that is formatted incorrectly and would like to
know if the following can be done (and if someone can help with the
code)...

- For a highlighted group of cells (single column)
- Take all data in the cell below the current cell except the last line
and add it to the current cell
- For each cell all the way down

The spreadsheet I have (long - too long to manually edit) looks like
this

Test1 A

Test2 B
C
A

Test3 B
C
A

So what I want is to highlight the ABC column of cells and have BC from
Test2 added to the end of Test1, and BC from Test3 added to Test2...
and so on. The only thing static is that I want to keep the last line
only... there are cells with 3 lines, some with 4 (BCDA), etc.

This spreadsheet is the result of a very large PDF that was converted
wrong... and is the only copy we have to work with.

I hope this is clear enough...

Thank you so much for any help!

Cory