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

I don't want to have to retype what you already have in an Excel sheet.

Please attach a sample workbook, and not a picture of one. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

The paperclip icon

can you post the excel sheet

I have a video on transposing data, I hope it helps

https://www.youtube.com/watch?v=w6evMNOaAnA

I have a video on transposing data, I hope it helps

https://www.youtube.com/watch?v=w6evMNOaAnA