<div>
<div class="content wysiwyg-content">
<a href="https://filedb.experts-exchange.com/incoming/2013/05_w20/655076/table.JPG" target="_blank" title="Sample Table (20 KB)"><img alt="Sample Table" class="file-block lazyload" style="max-width: 335px;" data-src="https://filedb.experts-exchange.com/incoming/2013/05_w20/655076/table.JPG" /></a>I have a table combined_list and I would like the output to be a pivot output that shows for each unique entry in column 0, to return for each year in column 1 have each value in column 2 <br />
<br />
For example<br />
<br />
PN &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2007 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2008 &nbsp; &nbsp; &nbsp; 2009<br />
<br />
AK801US#ABA &nbsp; &nbsp; &nbsp;7F &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7F &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 87<br />
AK802US#ABA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;87 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;88
</div>
</div>


table.JPG

I have a table combined_list and I would like the output to be a pivot output that shows for each unique entry in column 0, to return for each year in column 1 have each value in column 2 

For example

PN                         2007            2008       2009

AK801US#ABA      7F                7F           87
AK802US#ABA                          87          88

Pivot query with values

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.