I have a table that i need to display on screen but then rows as columns and columns as rows.
Can this be done?
Yes. In APEX there are (at least) 3 options:
1. Re: 4. How do I convert rows to columns? in the query.
2. Transposing the rows/columns using a custom report template.
3. Clunky looping in a Dynamic PL/SQL region.
Why is this necessary?