how to return same field data twice

[sirisha makkapati]

Dear Ranchers,

I Have a table like this

Uas_ref Uas_Name_En Uas_Type
1 No rights Acess_Name
2 Read and write Acess_Name
3 Admin Role_Name
4 User Role_Name
5 Monitering Role_Name

I have to returns rows as below

Uas_ref Role_Name Acess_Name
1 -- No Rights
2 -- Read and Write
3 Admin --
4 User --
5 Monitering --

Any one could tell me the query.
Thanks in advance.

Regards,
Sireesha.

[Jeanne Boyarsky]

Closing accidental duplicate thread. See original for answers.