Pair and Transpose Adjacent Records within the Group - From SQL to SPL #13

Problem description & analysis: A certain table stores records of personnel from external sources entering and leaving a building by swiping their cards in recent days. When a person enters and exits a building, there are usually N pairs of records, ...