How to change row into column in sql server

IF Less Columns are there we can use union also

EmpId	EmpName	DeptId	Salary	Gender	GenderName
13	Ash	2	8000	0	F
18	Renu	4	123	0	F
19	Raj	2	11000	1	M
20	Ramesh	5	25000	1	M


SELECT DISTINCT A.DeptId,SUM(A.M)AS M,SUM(A.F)AS F
FROM
(
Select  DeptId, Salary as M,0 as F From Employee Where Gender=1
Union
Select  DeptId,0 AS M, Salary as F From Employee Where Gender=0
)AS A
Group by A.DeptID


DeptId	M	F
2	11000	8000
4	0	123
5	25000	0

 create function [dbo].[patrak3_ugc_data_msc]
(
	
)
RETURNS @ugc_patarakno3 TABLE(sr_no int identity(1,1),
	college_id int,
	subject_paper varchar(255),	
	male varchar(50),
	female varchar(50),
	subject_paper2 varchar(255),	
	male2 varchar(50),
	female2 varchar(50),
	subject_paper3 varchar(255),	
	male3 varchar(50),
	female3 varchar(50),
	subject_paper4 varchar(255),	
	male4 varchar(50),
	female4 varchar(50)
	
)
	
as 
begin

DECLARE @Subject_Paper varchar(255)
DECLARE @male INT
DECLARE @female INT
DECLARE @srno INT
DECLARE @college_id INT


DECLARE MYCUR CURSOR STATIC LOCAL READ_ONLY FOR
select 
sd.swd_college_id,
Row_Number()over(PARTITION  BY swd_college_id order by swd_college_id ) as srno,
sm.Subject_Paper, 
SUM(case when em.gender=1 then 1 else 0 end) as male,
SUM(case when em.gender=2 then 1 else 0 end) as female
from semester_wise_student_data as sd,

	OPEN MYCUR
	FETCH NEXT FROM MYCUR INTO @college_id,@srno,@Subject_Paper,@male,@female
	WHILE @@FETCH_STATUS =0
	BEGIN
		
	
	IF(@srno = 1)
	BEGIN
		insert into @ugc_patarakno3 (college_id,subject_paper,male,female)values(@college_id,@Subject_Paper,@male,@female)	
	end	
	
	IF(@srno = 2)
	BEGIN
		update @ugc_patarakno3 set subject_paper2=@Subject_Paper,male2=@male,female2=@female where college_id=@college_id
	END
	
	IF(@srno = 3)
	BEGIN
		update @ugc_patarakno3 set subject_paper3=@Subject_Paper,male3=@male,female3=@female where college_id=@college_id
	END
	
	IF(@srno = 4)
	BEGIN
		update @ugc_patarakno3 set subject_paper4=@Subject_Paper,male4=@male,female4=@female where college_id=@college_id
	END
	
	FETCH NEXT FROM MYCUR INTO @college_id,@srno,@Subject_Paper,@male,@female
	END 
	
	
	CLOSE MYCUR
	DEALLOCATE MYCUR

Return 
end