how to Convert Columns into Rows?

Question

How i can convert columns into rows?

Rajesh Gami · Answer

Converting Columns into rows with their respective data in sql server ScripName ScripCode Price ----------------------------------------- 20 MICRONS 533022 39 ----------------------------------------- Data ColName ColValue ----------------------------- ScripName 20 MICRONS ScripCode 533022 Price 39 SQL Query declare @T table (ScripName varchar (50), ScripCode varchar (50), Price int ) insert into @T values ( '20 MICRONS' , '533022' , 39) select 'ScripName' as ColName, ScripName as ColValue from @T union all select 'ScripCode' as ColName, ScripCode as ColValue from @T union all select 'Price' as ColName, cast (Price as varchar (50)) as ColValue from @T

Rajesh Gami · Answer

Try This SELECT PD, [mon], [tue], [wed], ... FROM ( SELECT id, Day , PD, PDValue FROM ( SELECT id, Day , p1, p2, p3, p4 FROM TIMETABLE ) pvtData UNPIVOT (PDValue FOR PD IN (p1, p2, p3, p4)) ) AS unpvtData PIVOT (PDValue FOR Day IN ([mon], [tue], [wed], ...)) AS Final

Jignesh Kumar · Answer

Hi Dipak, Please use this link which will help you, https://www.sqlindia.com/convert-columns-into-rows-in-sql-server-using-values-and-unpivot/

Ashutosh Gupta · Answer

Deepak, did you check this link , log of example avaiable for you to refer and start with https://stackoverflow.com/questions/5337380/converting-columns-into-rows-with-their-respective-data-in-sql-server

Ashutosh Gupta · Answer

do you mean in database or UI ?

Farhan Ahmed · Answer

https://stackoverflow.com/questions/5337380/converting-columns-into-rows-with-their-respective-data-in-sql-server https://www.codeproject.com/Questions/1276737/How-to-convert-columns-to-rows-in-ms-SQL-server https://www.sqlindia.com/convert-columns-into-rows-in-sql-server-using-values-and-unpivot/

Navaneeth Krishnan · Answer

using pivot / unpivot https://www.c-sharpcorner.com/UploadFile/f0b2ed/pivot-and-unpovit-in-sql-server/

Harsh Shah · Answer

Using Unpivot. Unpivot is relational operator that is used to convert columns data into row. refer this article it will help you to convert columns into row. https://www.c-sharpcorner.com/UploadFile/f0b2ed/pivot-and-unpovit-in-sql-server/#:~:text=Pivot%20and%20Unpivot%20in%20SQL%20are%20two%20relational%20operators%20that,column%20level%20to%20row%20level.

Dipak Nile · Answer

hi Ashutosh Gupta by Using sql

Varun Setia · Answer

The pivot and unpivot concept will work, check this https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-ver15

how to Convert Columns into Rows?

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (10)