How to get sql output in the query mentioned

Transact-SQL
1

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

2