how to display intime and outtime in different columns

Question

the intime and outtime are in columns , but i need them likeI want it like this

Answer 1

I believe you are going to need to use the PIVOT operator. Here is another question similar to yours that has been answered.

Noel