Merging cells from next rows, then deleting the rows

[grinder]

My spreadsheet has a header record, then 3 rows per record set,
with 7 columns per row.
The first 4 columns are constant within each group of 3.
I would like to append cell E3 (text) to H2, and then cell F4 ( a date) to I2,
giving the 1st row 9 columns.
I then wish to delete the 2nd and 3rd row of each set.
I can do all this manually, by concatenating, copying and pasting special (values),
and then sorting to identify and delete the necessary rows,
but would obviously rather automate the task.

I have never written a macro before, and suspect I need one to accomplish my task.

Can anyone advise this novice how to go about this ?

Many thanks

[royUK]

Why 3 rows per record? All records should be on one row

[grinder]

Hi Roy
I have no control over the data : it is coming to me like this from an external application.
Best Regards

[BBGDan]

Hey Grinder, this would be no problem to do in Excel, but would you be able to attach an example of your file so that I can reference everything correctly, I do not want to work blindly on this only to find out your sheet looks different and the referencing doesn't work.
If you can do that then we should have this sorted quickly.
Lemme know,
Dan.