Help Transpose Data

B3=IF(AND($A2="",$A3<>""),$A3,"")
C3=IF(AND($A2="",$A3<>""),$A4,"")
D3=IF(AND($A2="",$A3<>""),IF(INDEX(A3:A18,4)="","",$A5),"")
E3=IF(AND($A2="",$A3<>""),TRIM(LEFT(IF(D3="",$A5,$A6),SEARCH(",",IF(D3="",$A5,$A6))-1)),"")
F3=IF(AND($A2="",$A3<>""),TRIM(LEFT(SUBSTITUTE(TRIM(MID(IF(D3="",$A5,$A6),SEARCH(",",IF(D3="",$A5,$A6))+1,256))," ",REPT(" ",20)),20)),"")
G3=IF(AND($A2="",$A3<>""),TRIM(RIGHT(SUBSTITUTE(TRIM(MID(IF(D3="",$A5,$A6),SEARCH(",",IF(D3="",$A5,$A6))+1,256))," ",REPT(" ",20)),20)),"")
tRY THIS AND COPY TOWARDS DOWN


SEE ATTACHED FILE