Hi
I Have a report with orders that I would to merge all the duplicate orders and add all the colors of all each order number.

I have This

Date |Order|Adress | Color |
Jan5 | 1      | abc     | blue |
Jan5 | 1      | ABC    | Green|
Jan9 | 2      | DEF     | red |

I woul like to have this result.

Date|ORDER | Addres | Color
Jan5| 1        | ADC     |   Blue, Green
Jan9| 2        | DEF     |    REd