Sql output from two columns

[Kristen]

Same answer as your previous question:

How to get sql output in the query mentioned

if data in two columns is something like Emp Dep 1 A 2 B c 3 4 D in sql output i want 1 2 3 4 in Emp and a b c d in dep. pleaselet me know how towrite query to get output? Thanks