Any ideas, especially on #1?
Christina - Thanks. One more question, if I may.
See my original post for the rows_tab & cols_tab query that APEX pivots.
Now if I already have a dataset of this form (rows going down and columns going across, how can I unpivot it back to the report view APEX shows? I can't figure out how APEX shows the stacked column headings. Basically, I have a sparse matrix report in an Excel spreadsheet that looks like the PIVOT version of the APEX IR and I want to load it up in a master-detail table structure with 1 row for each X (cell wih a value) in the matrix.
PIVOT and UNPIVOT operators make my head spin, appreciate the assistance :-)
Update: This is really a SQL question, I got help from the SQL forum. See here.