Hi Gurus,
Can anyone plz help with a query to disply rows in column, below is the sceniro.
I have table conating two fields 'Process' and 'Dep'
Process Dep
process1 Dep1
process1 Dep1
process1 Dep2
process1 Dep3
process2 Dep1
process2 Dep1
process2 Dep3
I need a query for out put which looks like below
Process Dep Dep Dep
Process1 Dep1 Dep2 Dep3
Process2 Dep1 Dep3
Thanks in advance