Arrange horizontal data to be vertical

Hill all, I would like to arrange multiple data in horizontal to be vertical


1 2 3 1 2 3
IV1511001 A BC C 1 2 3
IV1511001 X Y 1 1
IV1511001 X 2
IV1511002 T 1
IV1511002 Y M 3 1
IV1511003 U S 2 3
IV1511003 O G 1 1
IV1511003 P 1
IV1511003 Q 1

to be

IV1511001 A 1
IV1511001 BC 2
IV1511001 C 3
IV1511001 X 1
IV1511001 Y 1
IV1511001 X 2
IV1511002 T 1
IV1511002 Y 3
IV1511002 M 1
IV1511003 U 2
IV1511003 S 3
IV1511003 O 1
IV1511003 G 1
IV1511003 P 1
IV1511003 Q 1

1.jpg
2.jpg

Please see the attached file , thank you in advance