<div>
What version of MS SQL are you using? The PIVOT function would work if I am understanding what you are wanting to do.<br />
<br />
<a href="https://www.databasejournal.com/features/mssql/converting-rows-to-columns-pivot-and-columns-to-rows-unpivot-in-sql-server.html" rel="ugc">https://www.databasejournal.com/features/mssql/converting-rows-to-columns-pivot-and-columns-to-rows-unpivot-in-sql-server.html</a>
</div>


What version of MS SQL are you using? The PIVOT function would work if I am understanding what you are wanting to do.

https://www.databasejournal.com/features/mssql/converting-rows-to-columns-pivot-and-columns-to-rows-unpivot-in-sql-server.html [https://www.databasejournal.com/features/mssql/converting-rows-to-columns-pivot-and-columns-to-rows-unpivot-in-sql-server.html]

<div>
Hi Timothy,<br />
<br />
I use sql 2008.<br />
<br />
Please provide solution.<br />
<br />
Thank you.
</div>


Hi Timothy,

I use sql 2008.

Please provide solution.

Thank you.

<div>
What you need is a <a href="https://www.sqlshack.com/running-running-totals-sql-server/" rel="ugc">running total </a>with a bit of twist (minus 1)
</div>


What you need is a running total [https://www.sqlshack.com/running-running-totals-sql-server/]with a bit of twist (minus 1)

<div>
Hi John,<br />
<br />
Still don't get the idea ?<br />
<br />
Thank you.
</div>


Hi John,

Still don't get the idea ?

Thank you.

Capture.PNG

emi_sastra

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
I have below data :<br />
<br />

<pre><code id="code-10-29143763-1">1	AUDI
55	AUDI
109	ALFA ROMEO
127	BMW
181	BMW</code></pre>
<br />
I want to convert it into :<br />
<br />
1 &nbsp; &nbsp; &nbsp; &nbsp;54 &nbsp;AUDI<br />
55 &nbsp; &nbsp; 108 AUDI<br />
109 &nbsp; 126 ALFA ROMEO<br />
127 &nbsp; 180 BMW<br />
181 &nbsp; 181 BMW<br />
<br />
How could I do it ?<br />
<br />
Thank you.
</div>
</div>


Hi All,

I have below data :

(CODE)

I want to convert it into :

1        54  AUDI
55     108 AUDI
109   126 ALFA ROMEO
127   180 BMW
181   181 BMW

How could I do it ?

Thank you.

Arrange rows to colums

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.