sqlite converting a row result to column for listview android

I would like to display a query result (row) into a ListView (Column) with a single table. I am not sure how to do this. I was thinking of doing it with a for loop but didnt not work. Could someone help me please. I am working with 1 table.

Here is my table sample:

table name: ruling

number of columns: 75

regular search will display like this: (select * from ruling where name = charlie)

Note: the numbers are not number but block of text(full sentence / paragraph) table: ruling

 name        r1     r2     r3     r4     r5    ...... r75
 -------     --     --     --     --     --    ...... ---
 charlie      1      2      3      4      5    ...... 75

I want to display is the following result

charlie
1
2
3
4
5   
.
.
.
75

The reason is that with the result I want to capture it into a listView and I am not sure how to accomplish this.