Export ODS or EXCEL, Columns dynamic

Probably what you are searching is vertical table creation in ods report.