combine cells based on criteria

I'm looking to combine the vehicles based on column A.

e.g. a1:a3 has the same number so I need to combine like this; "2012 Toyota Prius V, 2013 Toyota Prius V, 2014 Toyota Prius V", and then the same for each other matching in column A.

=if(A2=A1,D2&" "&B2&" "&C2&", "&E1, D2&" "B2&" "&C2)

Then sort by column E (Z-A), then remove duplicates based on column A.

This works but eats up a lot of resources.

another option by using helper column F

1. F1=D1&" "&B1&" "&C1&IFERROR(","&VLOOKUP(A1,A2:$F$23,6,),"") then copy down
2. copy all number in A then paste it into column H, then remove duplicates
3. J1=VLOOKUP(H1,A:F,6,)