Hi, I have a table

select * from table

values returning are

login id | status_name | count
=============== =============== =
admin open 3
admin closed 5
test inprogress 10
test open 10
test closed 11
user1 closed 5
user1 pending 10

how can i transfer this data from row to column?
I want in this manner

...