Query to do a pivot

[FastEddie]

I have a table with columns like this EmpID, LastName, FirstName. So in the table a record looks like this:

EmdID     LastName   FirstName
-----------------------------
1	 Dent	   Arthur

What I need to do is take that row and pivot it like this:

EmdID      1   
LastName  Dent
FirstName  Arthur

From what I have gathered I think I need to use a Union Select to select my fields one at a time and then join them together at the end. I am having problems with the syntax though and haven't got passed the Select Statement. How do I accomplish this?