Aggregate column while keeping the rest of the columns

I have a table like below Item discount rate price Tesla 0.2 150 Ferrari 0.3 200 Honda 0.4 100 Tesla 0.2 300 Ferrari 0.3 400   As shown above, the "item" column wi...