query to transpose row data into column

[falaknaz]

i have result of query as below

CAJ74U	1	120131.82	3	H
CAJ74U	2	261783.82	2	H
CAJ74U	3	150373.57	1	H
CAJ74U	4	140402.12	1	H
CAJ74U	5	165292.85	1	H
CAJ74U	6	196789.4	1	H
CAJ74U	1	1352.62	        3	L
CAJ74U	2	1564.82	        5	L
CAJ74U	3	37444.57	2	L
CAJ74U	4	3530.57	        2	L
CAJ74U	5	13966.3	        4	L
CAJ74U	6	22816.85	3	L

and i want results like

CAJ74U	1	120131.82	3	1352.62  CAJ74U	2	261783.82	2	1564.82
CAJ74U	3	150373.57	1	37444.57
CAJ74U	4	140402.12	1	3530.57
CAJ74U	5	165292.85	1	13966.3
CAJ74U	6	196789.4	1	22816.85

[Rabbit]

Please use code tags when posting code or formatted data

I have no idea what you're trying to do, you have not explained your requirements clearly at all. Why are only some rows transposed and not the others? Why aare some rows filtered out?