A rather strange request and a bit limited I suspect but this should do it. Notice how I posted readily consumable ddl and data? This is something you should do in the future.

if OBJECT_ID('tempdb..#Something') is not null

drop table #Something

create table #Something

(

RowPointer char(7),

Notes char(10)

)

insert #Something

select 'Row0001', 'TestNotes1' union all

select 'Row0002', 'TestNotes2' union all

select 'Row0003', 'TestNotes3'

select top 1 RowPointer, STUFF((select Notes + char(10)

from #Something

order by RowPointer

for XML PATH('')), 1, 0, '')

from #Something