Row as column

CREATE TABLE dbo.tblCars(RecordID INT IDENTITY(1,1) PRIMARY KEY NOT NULL,DealerID INT NOT NULL,Make NVARCHAR(50),MakeYear SMALLINT,CarsSold INT)select * from information_schema.tablesselect * from tblcars
INSERT INTO dbo.tblCars SELECT 1, 'Honda', 2003, 100INSERT INTO dbo.tblCars SELECT 2, 'Toyota', 2003, 500INSERT INTO dbo.tblCars SELECT 2, 'Honda', 2003, 200INSERT INTO dbo.tblCars SELECT 1, 'Honda', 2004, 200INSERT INTO dbo.tblCars SELECT 1, 'Toyota', 2004, 600INSERT INTO dbo.tblCars SELECT 2, 'Honda', 2004, 300INSERT INTO dbo.tblCars SELECT 2, 'Toyota', 2005, 50
SELECT Make, [2003], [2004], [2005] FROM(SELECT Make, CarsSold, MakeYear FROM dbo.tblCars) tblCarsPIVOT (SUM(CarsSold) FOR MakeYear IN ([2003],[2004], [2005])) tblPivot