consolidating rows

am importing Data into excel using copy and paste

Because of the format i am coping from, the data is pasted into multiple rows instead of one long row for each data point.

Attached is a example. All the Data From C3:C5 should be in one consolidated row. Starting with the Date and ending with the amount. IN this case it should look like What is below the Yellow Line.

Note: Rows C24:C28 Need no editing, but the formula would have to be applied to every rows C3:C28

I need everything that is not a transaction to be deleted. All the Transactions Begin with Dates. (If that helps) So everything from C11:C14 should be deleted. Because it is not a transaction and does not START with a date

These are two seperate questions kinda, But an answer to either one will be much appreciated