Rows into columns sql

Question

I am reading an excel file using sql

select ISNULL(F4,'RCS(mean)') AS WEB1_CD,cast(round(F5,2) as numeric(36,1)) 
   AS Value,ISNULL(F9,'RCS(mean)') AS WEB_MD,F10 AS Value from 
     OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0 
       Xml;Database=D:\_TPRCS\SampleFileForStudy.xlsx;HDR=YES','select * FROM 
         [0537259$B22:K28]') WHERE F5 IS NOT NULL

and the result is

Now I want to make my rows as columns so I can get my variables value. I want result as in below image

what kind of detail dear @ali i have my result set all i want is to convert them into coulmns — Rizwan Ali Sabir, Jul 17 '17 at 11:29
https://stackoverflow.com/questions/15297809/sql-transpose-full-table — Vityata, Jul 17 '17 at 11:30
Please show your expected output, I don't understand what you want here. — Tim Biegeleisen, Jul 17 '17 at 11:31
ok @TimBiegeleisen please refresh i have added an image in last — Rizwan Ali Sabir, Jul 17 '17 at 11:31

score 0 · Accepted Answer · answered Jul 18 '17 at 10:22

I did it by using SQL PIVOT

SELECT [RCS(mean)] ,[STDEV], [Min],[Max]
FROM (SELECT ISNULL(F4,''RCS(mean)'') as val ,F5 FROM OPENROWSET(''Microsoft.ACE.OLEDB.12.0'', ''Excel 12.0 Xml;Database=D:\_TPRCS\SampleFileForStudy.xlsx;HDR=YES'',''select * FROM [Sheet1$f24:k28]'') ) up
PIVOT (MAX(F5) FOR val IN ([RCS(mean)],[STDEV], [Min],[Max])) AS pvt

Rows into columns sql

1 Answers1