You are grouping by both ID and LubeTyepID, which means if either is unique it will show as a unique row. If you don't want to show repeats, don't group by the LubeTypeID and only group by ID.
You would probably need to write a custom IF statement to see if the type changed row by row and only show it when it changes.