Loading

Convert the Datatable column value into column

Sakthikumar Thanavel

Hi guys,

I am facing one difficulties in my project. I need to convert column value as a new column like,

Can you share your idea with me?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sakthikumar Thanavel10y ago
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 Menoth10y ago
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 Sohail10y ago
You can use cross Tab / Pivot for this purpose