Hi Makumbi,
Please refer below sample query.
SQL
CREATE TABLE [ConvertColumnTORow]
(
[Days] VARCHAR(20),
[01:00-01:30] VARCHAR(50),
[02:00-02:45] VARCHAR(50),
[01:00-02:30] VARCHAR(50),
[11:00-11:45] VARCHAR(50),
[01:00-02:00] VARCHAR(50),
[01:00-02:45] VARCHAR(50),
[03:00-03:30] VARCHAR(50)
)
INSERT INTO [ConvertColumnTORow] VALUES('Wednesday','S1K:MS:CN', 'S1K:MS:CN', 'S1K:MS:CN', 'S1K:MS:CN', 'S1K:MS:CN','S1K:MS:CHE', 'S1K:MS:CHE')
SELECT Days, [01:00-01:30] AS 'Convertedrowdata' FROM [ConvertColumnTORow]
UNION ALL
SELECT Days, [02:00-02:45] FROM [ConvertColumnTORow]
UNION ALL
SELECT Days, [01:00-02:30] FROM [ConvertColumnTORow]
UNION ALL
SELECT Days, [11:00-11:45] FROM [ConvertColumnTORow]
UNION ALL
SELECT Days, [01:00-02:00] FROM [ConvertColumnTORow]
UNION ALL
SELECT Days, [01:00-02:45] FROM [ConvertColumnTORow]
UNION ALL
SELECT Days, [03:00-03:30] FROM [ConvertColumnTORow]
Output
