By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,659 Members | 1,611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,659 IT Pros & Developers. It's quick & easy.

Transpose into fixed column

P: 7
Hi all,

I have following table with 2 columns

ID | TIME
=========
A 07:01
A 12:05
A 12:59
A 15:09
B 15:07
C 06:52
C 12:47
C 17:03
D 07:00
D 18:12
D 18:57
D 21:04

Now i want to transpose them into this table with 7 columns

ID T1 T2 T3 T4 T5 T6
============================================
A 07:01 12:05 12:59 15:09
B - - - 15:07
C 06:52 - 12:47 17:03
D 07:00 - - 18:12 18:57 21:04
Jul 22 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.