Find Unique Values and String Concatenation

I have a dynamic column with Orders Key. These are repeating. I need to find unique values and show horizontally with comma delimited value as in attachement. And also need to get no of unique order count.

Note: I need solution in 2007 version no Micros, only functions.