Declare @t table
(
	Series varchar(50),
	S1 varchar(50),
	S2 varchar(50),
	S3 varchar(50)
)

Insert into @t 
Select 'Label1','','','' union
Select 'Label2','','','' union
Select 'Label3','','','' union
Select 'Label4','','','' 

Select * from @t

Above OutPut 

Series      S1     S2   S3
Label1			
Label2			
Label3			
Label4	

Actually Label1,2,3 were fetch from table, the value may change. So My required output
is like below

Series      S1     S2   S3
Label1
Open
Close			
Label2			
Open
Close
Label3			
Open
Close
Label4			
Open
Close

Need to bring Open and close between of the Every labels. How to bring achieve the above result.Kindly guide me,through sample codes

Select 
	r = A.r + B.n,
	Series = case B.n when 0 then A.Series when 1 then 'Open' when 2 then 'Close' else null end,
	S1 = case B.n when 0 then A.S1 else '' end,
	S2 = case B.n when 0 then A.S2 else '' end,
	S3 = case B.n when 0 then A.S3 else '' end
From
	(
	Select 
		r = ROW_NUMBER() Over(Order By Series) * 3-2,
		* 
	From @t
	) A
Cross Join (Select n=0 Union All Select 1 Union All Select 2) B