Convert the Datatable column value into column

Question

Hi guys I am facing one difficulties in my project. I need to convert column value as a new column like Name Department SubjectName Mark Sakthi MCA C 80 Sakthi MCA Datastructure 70 Kumar BE C 60 Kumar BE CPP 75 Kumar BE Maths 80 Name Department C Datastructure CPP Maths Sakthi MCA 80 70 Kumar BE 60 75 80 Can you share your idea with me?

Sakthikumar Thanavel · Answer

Hi In this case should I use any aggregate function? But i don't need aggregate function. is it possible? For details Please view that above table.

Rajeesh Menoth · Answer

Hi You can use Pivot. Reference : http://www.databasejournal.com/features/mssql/converting-rows-to-columns-pivot-and-columns-to-rows-unpivot-in-sql-server.html

Kashif Sohail · Answer

You can use cross Tab / Pivot for this purpose

Name	Department	SubjectName	Mark
Sakthi	MCA	C	80
Sakthi	MCA	Datastructure	70
Kumar	BE	C	60
Kumar	BE	CPP	75
Kumar	BE	Maths	80

Name	Department	C	Datastructure	CPP	Maths
Sakthi	MCA	80	70
Kumar	BE	60		75	80