How to get this kind of data?

Question

I have data some thing like this:

+---------+---------+---------+-------+
| MAXIMUM | MINIMUM | SENSORS | TIME  |
+---------+---------+---------+-------+
|      10 |      12 |      14 | 13:12 |
|      80 |      70 |     100 | 14:54 |
+---------+---------+---------+-------+

But I need something like this:

+---------+-------+
|    X    |   Y   |
+---------+-------+
| MAXIMUM | 10    |
| MINIMUM | 12    |
| SENSORS | 14    |
| TIME    | 13:12 |
| MAXIMUM | 80    |
| MINIMUM | 70    |
| SENSORS | 100   |
| TIME    | 14:54 |
+---------+-------+

How to get this kind of data is there any possibility to get data?

Possible duplicate of [Unpivot with column name](https://stackoverflow.com/questions/19055902/unpivot-with-column-name) — Hasan Gholamali, May 12 '18 at 09:29

score 3 · Answer 1 · answered May 12 '18 at 10:46

Just another option

Example

Select B.*
 From  YourTable
 Cross Apply (values ('MAXIMUM',convert(nvarchar(50),MAXIMUM))
                    ,('MINIMUM',convert(nvarchar(50),MINIMUM))
                    ,('SENSORS',SENSORS)
                    ,('TIME'   ,convert(nvarchar(50),[TIME],108))
             ) B(x,y)

Returns

x          y
MAXIMUM    10
MINIMUM    12
SENSORS    14
TIME       13:12:00
MAXIMUM    80
MINIMUM    70
SENSORS    100
TIME       14:54:00

score 2 · Answer 2 · answered May 12 '18 at 10:09

You can use UNPIVOT:

declare @tmp table (MAXIMUM  nvarchar(10), MINIMUM  nvarchar(10), SENSORS   nvarchar(10), [TIME] nvarchar(10))
insert into @tmp select    10,12,14 ,'13:12'
insert into @tmp select    80,70,100,'14:54'

select u.x,u.y
from @tmp s 
unpivot 
( 
[y] 
for [x] in ([MAXIMUM],[MINIMUM],[SENSORS],[TIME]) 
) u;

Results:

How to get this kind of data?

2 Answers2