how to Convert Columns into Rows?

Dipak Nile

6y1.5kSQL

How i can convert columns into rows?

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Farhan Ahmed5y ago
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/
Varun Setia5y ago
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
Rajesh Gami5y ago
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 Gami5y ago
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 Kumar6y ago
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/
Navaneeth Krishnan6y ago
using pivot / unpivot

https://www.c-sharpcorner.com/UploadFile/f0b2ed/pivot-and-unpovit-in-sql-server/
Harsh Shah6y ago
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.
Ashutosh Gupta6y ago
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
Dipak Nile6y ago
hi Ashutosh Gupta

by Using sql
Ashutosh Gupta6y ago
do you mean in database or UI ?