how to concatenate Text type data

Hi,
I need to fetch the value from a column which is of type TEXT, and then I need to concatenate the values of all the rows for that same column and store it into a new table. I mean, if I have a column with the name Address of type TEXT. Then I need to merge all the available address.
Can some one help me with this?

Thanks
Arun