Get the data from the table in the form of fieldname and fieldvalue in SQL Server
UNPIVOT can help you with this.

Try something like 

SELECT employeenumber, fieldname,  fieldvalue
FROM tblmployee e
UNPIVOT(
    FieldValue
    FOR FieldName IN (Gender, JoinDate, MobileNo)
) U


Hope that helps