Hi all, Is there a simple way to split my columns so that I can get File 2 starting from File 1? Please, see the attachment. Thank you in advance, Steve. FILE 1: Initial                                                           Employee ID Appointment date Classification Level Salary Number of appointments                   1 1 AS 2 40 000 2                   1 2 AS 3 50 000 2                   2 1 EC 6 100 000 1                   3 1 CS 1 50 000 3                   3 2 CS 2 60 000 3                   3 3 CS 3 80 000 3                   4 1 EX 3 150 000 1                                                 FILE 2: Expected                                                         Employee ID Appointment date_1 Class_1 Level_1 Salary_1 Appointment date_2 Class_2 Level_2 Salary_2 Appointment date_3 Class_3 Level_3 Salary_3 Number of appointments   1 1 AS 2 40 000 2 AS 3 55 000         2   2 1 EC 6 100 000                 1   3 1 CS 1 50 000 2 CS 2 60 000 3 CS 3 80 000 3   4 1 EX 1 150 000                 1                                                               ... View more