VB script to arange pasted data

Hi

I am starting a data sheet that I will be pasting from the internet into my data sheet daily, the problem I have is that the content data is pasting with blank rows between data and also there is one piece of data that is situated on the row below which i need moving to the end of the main data row, the idea is to have single data rows with no blank rows.

I have attached an example sheet showing the layout it repeats with only the amount of data that changes.

I have coloured the data as follows:

Grey= Blank Rows
Yellow= Data Move to end of main row
Green= Unwanted Data

Really hope someone can come up with something.

Thank you

Yes yes and yes if theres a way to delete the green columns so yellow follows at end without blank columns, that would be magic.

Thanks very much for your help