Data display vertically

[arunku]

Hi,

I have one more query . The report in which am working is as below cell by cell vertically.


pointsBalance:44616
User HM245613
pointsBalance:78092
User GRK63711
pointsBalance:36615
User VHN56986
pointsBalance:135484
User GL764905
pointsBalance:304235
User EA976761



My requirement is to display in two cells as below . I tried with transpose but not yielding results,Please help on this

PointBalance User
44616 HM245613
78092 GRK63711

[Special-K]

in E1
=SUBSTITUTE(INDEX(A$1:A$11,(ROW())*2-1,1),"pointsBalance:","")
in F1
=SUBSTITUTE(INDEX(A$1:A$11,(ROW())*2,1),"User ","")

copy down the columns

[arunku]

Thank You,this method worked