delete old duplicate items by sorting not loop

[Hasson]

Hello
I want delete the old data . should keep the last duplicate items (should be by sorting not loop if it's possible) based on column C .

(6).xlsx
	A	B	C	D
1	ITEM	CODE	ID	QTY
2	1	BS-TA-113	QQW-14 L/R CLA14 SS230 EG DF/100	12
3	2	BS-TA-117	QQW-181 RRSDF BRI	234
4	3	BS-TA-113	QQW-14 L/R CLA14 SS230 EG DF/100	400
5	4	BS-TA-119	QQW-20 KV/1**2 CLA20 CV	123
6	5	BS-TA-107	QQW-8 CLA8 UKI	456
7	6	BS-TA-113	QQW-14 L/R CLA14 SS230 EG DF/100	600
SHEET1

result

(6).xlsx
	A	B	C	D
1	ITEM	CODE	ID	QTY
2	2	BS-TA-117	QQW-181 RRSDF BRI	234
3	4	BS-TA-119	QQW-20 KV/1**2 CLA20 CV	123
4	5	BS-TA-107	QQW-8 CLA8 UKI	456
5	6	BS-TA-113	QQW-14 L/R CLA14 SS230 EG DF/100	600
REPORT

my real data are 4000 rows
thanks

 

[Hasson]

@lrobbo314 PQ excellent choice !
I don't use to using PQ , even if that I have some question .
1- you do that in the same sheet , how do that ?
actually create new sheet when I do that.
2- can re utonumbering in column A after delete it 1,2,...?
3- is it way refresh the data in PQ after update in orginal data without using refresh in right click (just automatically)?
thanks