Export List or Generate report where columns and rows are swapped

[miles9]

HI all, 

I am hoping someone had an actual answer for this.  I looked at a few posts that I could find regarding this requirement that I have and can't find a solution.

The issue, I need to export to xlsx or even csv and I need it where if possible their is a column that lists the servicenow numbers, the years are columns and the "fields"/"values" are the rows.

Current way my exports look like where the "stuff" are my columns with the corresponding rows equating to the unique entries with associated values.  Whereas the above image I need the columns to be the years and each corresponding row to be the "stuff" or the associated values.

 

 

If this isn't clear please let me know and I'll try to provide more clarifying details.

Thank you 

[Bert_c1]

Is that a list view of records in a table? If so Export to xls or cvs format is available.

[miles9]

yes, a list view either via a report  generation or just exporting from the list view.  but the issue isn't exporting to the format of xlsx or csv.  the issue is the columns and rows.  

[Bert_c1]

Hi miles9,

That is a feature of Excel, see:

transpose-rotate-data-from-rows-to-columns-or-vice-versa

Also, a pivot table report, good luck.