Help With Pivot For GridView

Hello, I have a query that works, it produces this:
UserID     UserName   GMC   Buick   Used 1                Jesse          1         2         1 2                Mark           4         3         2
But I need to pivot it, so that it appears this way
                  Jesse          Mark GMC              ...