Concat two colums in straight table with repeat

[Victorysai]

Hi I have a table.

ID	EMPLOYEE NAME	AUDIT PLACE
E123	PAVAN	HYD
E123	PAVAN	UI
E124	SAI	VSP
E111	KUMAR	HYD
E124	SAI	HHH

I need the following output in straight table:

ID	EMPLOYEE NAME / AUDIT PLACE
E123	PAVAN / HYD UI
E124	SAI / VSP HHH
E111	KUMAR HYD

I used EMPLOYEE NAME&chr(10)&AUDIT PLACE, but its not working. 

Please help me

[MarcoWedel]

maybe like this?

Concat(distinct [EMPLOYEE NAME], Chr(10))&' /'&Chr(10)&Concat(distinct [AUDIT PLACE], Chr(10))