Combine different rows into 1 column

[umair434]

Hi all,

I have a table which shows when a product is available in the stores.

For example.

Product Store Available
A NS Jan, 2013
A BC Marc, 2013

How can I combine the available/store field which just shows

Product Available:

A - Jan, 2013 in NS AND Mar, 2013 in BC.

any idea?

 

[pbaldy]

You can adapt a function like this:

http://support.microsoft.com/kb/210163/en-us