Need help with creating a macro that will insert a new column and extract the first value

I need help with creating a dynamic macro that will insert a new column on the side and extract the first "expected cost" of each "model" and delete the rest of the rows.

Below is the part of the dataset that I need to use to create this macro.

Here is the example/result that I am looking for.
As you can see on the bottom, there are five different models. Each model has 2 or 3 expected cost.
I want to create a dynamic macro that will extract the first expected cost for each model and put them into separate column.
So, Model: WM3370HWA.ABWEPUS will have expected cost of 4, WM4270HWA.ABWEPUS will have expected cost of 1693, WM8000HWA.ABWEEUS will have expected cost of 1147 and so on.

Your help will be greatly appreciated.

Model Expected Cost(Editable)
WM3370HWA.ABWEPUS 4
WM3370HWA.ABWEPUS 321
WM3370HWA.ABWEPUS 38
WM4270HWA.ABWEPUS 1693
WM4270HWA.ABWEPUS 12721
WM8000HWA.ABWEEUS 1147
WM8000HWA.ABWEEUS 8584
WM8000HWA.ABWEEUS 29
WT5680HVA.ASSEPUS 1800
WT5680HVA.ASSEPUS 13519
DLEX4270W.ABWEEUS 987
DLEX4270W.ABWEEUS 7384
DLEX4270W.ABWEEUS 33