Enni

Enni

  • NA
  • 30
  • 4.5k

Separate columns values as another column

Aug 1 2018 3:54 AM
Hi, I found the following requirement some where in the google, please help me to acheive it.
 
Input 
ID Tim
1 9:05:00
2 9:10:00
1 10:00:00
2 10:15:00
1 11:00:00
1 11:30:00
2 11:45:00
2 11:50:00
 
Output: 
 
1 9:05:00 2 9:10:00
1 10:00:00 2 10:15:00
1 11:00:00 2 11:45:00
1 11:30:00 2 11:50:00

Answers (1)