how to put column name in fields of table in query_table

Need help to create zoho report from tables by selecting column name and respective values sorted according to date

for eg: see attached file snapshot

can we design zoho table by query_report or report view, if possible please provide help regarding it.

and we are getting result from table

please provide help if any problem in query execution

and how to get pivot view on clicking on one pivot view in child window