Sqlite from column values to single column row values

help me how to write this query for below output.find my table data

id cat sub-cat sub-sub
1 remarkable
2 bsorpti_upd
3 ntimicrobiasdfsdf
4 remarkable Dissolve
5 macokinetics
6 pharmacodynamics
7 pharmacodynamics Antimicrobial
8 pharmacodynamics Antimicrobial peptite
9 Test
10 ideas
11 Test biologically

I want my output as

column

Remarkable
         Dissolve
bsorpti_upd
ntimicrobiasdfsdf
macokinetics
pharmacodynamics
        Antimicrobial
               peptite
Test
     biologically
ideas
1 Like

SELECT cat, sub-cat FROM [TableName] ORDER BY cat ASC

As far as formatting, what app are you using to query the database?