How do I display data in my grid in following format

See more:

C#

ASP.NET

SQL

i have one gridview in that i want to display data as below

Timeline ->	Week-1	        Week-2	        Week-3
Date -> Week Starting	02/22/2016	02/29/2016	03/07/2016
Target Stage  Desc.	Desc 1          desc 2          desc 3
Target Step Code	1	1	1
Target Step Date	03/13/2016	03/13/2016	03/13/2016
Actual Step Code	1	1	1
Status	                On Track	On Track	On Track
Comments                Comment 1       comment 2       commet 3

and i have data in my table as follows

	PWId	ProjectId	StageId	WeekId	WeekStartingDate	TargetStepCode	ActualStepCode	ActualStartingDate	Status	Comments
1	1	10	1	1	2016-02-22 00:00:00.000	1	1	2016-02-22 00:00:00.000	NULL	'Trials planned in Ahmedabad, Surat, Kanpur, Lucknow
2	2	10	1	2	2016-02-29 00:00:00.000	1	NULL	2016-03-13 00:00:00.000	NULL	'Internal videos of the product application in various substrates created
3	3	10	1	3	2016-03-07 00:00:00.000	1	NULL	2016-03-13 00:00:00.000	NULL	'Estimation of Market potential for the product in FCs done through FCSI Study
4	4	10	2	4	2016-03-14 00:00:00.000	2	NULL	2016-04-22 00:00:00.000	NULL	'Market potential estimated at 10000 pcs per month through the FCSI study
5	5	10	2	5	2016-03-21 00:00:00.000	2	NULL	2016-04-22 00:00:00.000	NULL	'23 Product trials completed in selected cities of Surat, Kanpur, Lucknow and Ahmedabad. 
6	6	10	2	6	2016-03-28 00:00:00.000	2	NULL	2016-04-22 00:00:00.000	NULL	NULL

please suggest something i have tried with pivot bt it is not working
i want weekid column horizontally i can used pivot for that bt for the next column to be shown as next row and next to that there data

thanks in advance

What I have tried:

i have tried with pivot