How do I merge cells in the center of a worksheet?

For example, I have 5 rows (call them 190 thru 195) which I want to
turn into 1 row.
The data is in the first 5 columns.
In column A, the data is in row 194
In column B, there is no data
In column C, the data is in rows 190, 191 and 192
In column D, the data is in all 5 rows
In column E, the data is in row 190 and 193

All data is text. Each set of data takes up anywhere from 3-5 rows,
each one different. I ended up with the spreadsheet in this format by
cutting and pasting from a word spreadsheet. Wherever there was a
bullet point the data jumped to a new row. I no longer have the
original word doc.

The end product should be a single row, with each column containing the
original data from all of its rows, appended.

I have a total of about 250 rows which need to be closer to 50-60 rows,
so cutting and pasting into a new spreadsheet would take all day. Any
help would be very appreciated. Thanks!

Mike Simard