Transpose Table Header

[pturmel]

I'm sure I've commented on this topic before.....
Yep, a quick search of the forum with just the key word 'transpose' yields this:

Transpose Rows and Columns

I have a table component displaying daily flow totals on each day of the week. It executes an sql query which returns a dataset with each item name as a column and each day as a row. For display purposes I’d like to transpose the rows and columns so that the days are displayed along the top and item names along the side. I’ve been trying to accomplish this with scripting. It seems such a simple operation but it’s proving much more difficult than I thought. Is it actually possible or does this …