Good day everyone, this is my first post and I'm still fairly new to SAS, so please be gentle 🙂   Initial data: NO ID DATE TIME1 LAT1 LONG1 TIME2 LAT2 LONG2 01 BB 3Mar20 10:05 44.10 -52.01 10:59 44.15 -52.11 02 CC 3Mar20 11:15 44.20 -52.22 12:08 44.22 -52.32 03 DD 3Mar20 12:09 45.30 -52.33 13:44 44.33 -52.43 04 EE 3Mar20 14:22 44.40 -52.44 15:33 44.55 -52.77   NO ID DATE TIME LAT LONG 01 BB 3Mar20 10:05 44.10 -52.01 02 BB 3Mar20 10:59 44.15 -52.11 03 CC 3Mar20 11:15 44.20 -52.22 04 CC 3Mar20 12:08 44.22 -52.32 05 DD 3Mar20 12:09 45.30 -52.33 06 DD 3Mar20 13:44 44.33 -52.43 07 EE 3Mar20 14:22 44.40 -52.44 08 EE 3Mar20 15:33 44.55 -52.77   So basically I want to keep all 1's (TIME, LAT, & LONG) on the first line and put all 2's on the second line.   I've tried playing around with Transpose but to no success! ... View more