Hello All,
Pls suggest me something for the problem I am facing below.
I have 2 columns(Manager ID and Dept Name)
Data
Manager ID as 1 and Dept name as A
Manager ID as 1 and Dept name as B.
I want to display as Manager ID 1 andDeppt name A,B
I have written a formula but the result i ma getting is
Manager ID 1 and Dept name A
Manager ID 1 and Dept name A,B
please suggest how can i avoid getting 'Manager ID 1 and Dept name A'
and get only 'Manager ID 1 and Dept name A,B'
Thanks Robinn