Combine multiple row data into one cell

[system]

This flattening data into a single row business seems to be the hot topic lately!

Anyway, have a look at this post - might be a good starting point:

120×120 10.4 KB

I have a report showing Item, Price and colour like this: Item Price Colour A £1 black A £1 red B £2 green B £2.50 black I want to show item A in one row, (since both item code and price are same), like this Item Price Colour A £1 black, red B £2 green B £2.50 black How can I do this ? Thank you bulgaru10 (BOB member since 2006-12-15…

---

Atul Chowdhury (BOB member since 2003-07-07)