concatenate all fields in a given column

[#1]

I'm trying to display the procedure source code from a database.
The problem I'm having is that the database is giving me the source code line by line.
So I currently have something like this..

Name      line     text

A            1         start
A            2         begin
A            3         blahblahblah
B            1         start
B            2         end

So for example, if I select A
I want it to show in a text box formatted as:
start

begin
blahblahblah

while if i select B:

start

end

Any method would be awesome.

Is there anything i can do maybe even in the script so i can only get

Name        Text

A               start (newline) begin (newline) blahblahbalh
B               start(newline) end(newline)

Thanks!

[Gysbert_Wassenaar]

Try concat(distinct [Text], chr(10))

[#3]

it doesn't seem to be in order

[Gysbert_Wassenaar · Accepted solution]

If the line field determines the order: concat(distinct [Text], chr(10), line)