<div>
Great! Will you close off the question please?
</div>


Great! Will you close off the question please?

<div>
Thank you. Closure of questions is really appreciated. <br />
<br />
Cheers<br />
Paul
</div>


Thank you. Closure of questions is really appreciated.

Cheers
Paul

<div>
You are welcome Paul and really sorry i did not realise that i had not closed the question.<br />
<br />
regards
</div>


You are welcome Paul and really sorry i did not realise that i had not closed the question.

regards

<div>
<div class="content wysiwyg-content">
Hi Guys, <br />
I need to convert rows into columns. My requirement is that a postcode can have several addresses like below.<br />
<br />
AB1 2DE , Address 1<br />
AB1 2DE, Address 2<br />
AB1 2DE, Address 3<br />
..........................<wbr />.......<br />
..........................<wbr />.......<br />
AB1 2DE, Address N<br />
AB2 1DE, Address 1<br />
''''''''''''''''''''''''''<wbr />''''''''''<wbr />''''<br />
AB2 1DE, Address N<br />
<br />
I want to display all the addresses of a postcode as columns <br />
AB12DE Address1 Address2 Address3 .........................A<wbr />ddress N<br />
AB2 1DE Address1 Address2 Address3 .........................A<wbr />ddress N<br />
<br />
Please note i am using SQL Server 2014<br />
<br />
Kindest regards
</div>
</div>


Hi Guys, 
I need to convert rows into columns. My requirement is that a postcode can have several addresses like below.

AB1 2DE , Address 1
AB1 2DE, Address 2
AB1 2DE, Address 3
.................................
.................................
AB1 2DE, Address N
AB2 1DE, Address 1
''''''''''''''''''''''''''''''''''''''''
AB2 1DE, Address N

I want to display all the addresses of a postcode as columns 
AB12DE Address1 Address2 Address3 .........................Address N
AB2 1DE Address1 Address2 Address3 .........................Address N

Please note i am using SQL Server 2014

Kindest regards

Convert rows into Columns in SQL Server, T-SQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.