Hello,

I was wondering if someone could help me out with the following. I'm
trying to group mutiple rows into a single row using the concatenate
function. However, my trouble lies in the way my data is sorted as
follows:

Name Description
a z
a y
a x
b w
b v
c u
c t
c s
c r

What I want to do is put the discription into one single line so that
my data is presented as follows:

Name Description
a z y x
b w v
c u t s r

Does anyone know of a macro or formula that would help me achieve this?
If you need any further info, please let me know. Thanks!

Xavier