Duplicate Entries in Rows - Add Accompanying Data to New Columns

I have attached a before and after image of what I am looking to accomplish.

In the before image, you can see that there are 3 rows of data
- a header
- a repeating model number (in column F) with accompanying data (values in columns G - J are the items of interest)

In the after image, you can see that I took the 3 rows of data and turned it into simply two rows of data
- a header
- the repeating model number

What I did however in the after image, as can be seen, is I took the data that appeared on the repeating row (Row 3 from the Before image), and included the PRICE, COST, BEGIN, and END values in new columns on row 2.

The model number is the same of course, which is why I did it that way.

If the model numbers were different, I would have simply left it alone, as-is.


Is there a way to accomplish this via some functions or maybe even a VBA script?

By the way, if we have to dump all of this onto a new sheet, then so be it.


Thanks in advance!