To get the column names based on value

[koolcham]

I have Employee table
Eg:
Fn Ln Eid EmpOrgStr MngrOrgStr
a a a1 a1 b1
b b b1 b1
c c c1 c1 b1
d d d1 d1 b1

when i use select query i should get the result as below
Fn Ln Eid EmpOrgStr MngrOrgStr MnFn MnLn
a a a1 a1 b1 a a
b b b1 b1
c c c1 c1 b1 a a
d d d1 d1 b1 a a

[Rabbit]

I have no idea how you derived those two columns.