How to replace the row and column in SQL server

--create table for importing data
create table DataImpTest
(
Title1 varchar(100),
Title2 varchar(1000)
)

--do the bulk insert
BULK INSERT DataImpTest  
   FROM '<File Path>\DataImp.csv'  
   WITH  
     (  
        FIELDTERMINATOR =' ',  
        ROWTERMINATOR = '\n',
		FIRSTROW=2
      );  

--check the imported data
	  SELECT * FROM DataImpTest

-- fix the unequal spacing in Title2 column
	  UPDATE DataImpTest
	  SET Title2 = LTRIM(RTRIM(Title2))

--check the trimmed data
	  SELECT * FROM DataImpTest

	  --pivoting the data to columns
	  SELECT *
	  FROM DataImpTest AS t
	  PIVOT(MAX(Title2) FOR Title1 IN ([Name],[State],[PSComputerName],[RunspaceId]))p


/*
Output
---------------------------------------
Name	                State  PSComputerName	RunspaceId
-----------------------------------------------------------------------------
Default Web Site	Stopped	s07	c62cf173-af1f-46bd-a57f-3b29e74998ed