Pls help me with this macro:

I have data which has the following format

Row1 A B C D E F G H
I J K L M N
Row2 9434 20060111 231 56 1.1 TEP 37 1.2 TEQ
0 0 TER 0 0

The data goes to column BJ.

I wish to to sort this data as follows

A B C D E
9439 20060111 231 56 1.1
9439 20060111 TEP 37 1.2
9439 20060111 TEQ 0 0
9439 20060111 TER 0 0

Thanks