convert columns to rows and rows to columns

[helpful sql]

Hi all,
I am using an HTML table control on my ASP.Net page. Now I need to
change this table so that columns become rows and rows become column. Since
the table is very complex with many controls in them, I am wondering if
there is any way to do this in visual studio 2003 or using any other tool.

Thanks in advance.

[DKode]

please don't cross post against multiple newsgroups. You'll be lucky if
anyone responds to your thread.

[Ken Tucker [MVP]]

Hi,

You need to create a pivot table. Maybe this will help

http://www.sqlteam.com/item.asp?ItemID=5741

Ken
-------------------
"helpful sql" <no****@stopspam.com> wrote in message
news:eg**************@TK2MSFTNGP09.phx.gbl...
Hi all,
I am using an HTML table control on my ASP.Net page. Now I need to
change this table so that columns become rows and rows become column. Since
the table is very complex with many controls in them, I am wondering if
there is any way to do this in visual studio 2003 or using any other tool.

Thanks in advance.

[helpful sql]

Sorry but I think this is a good place for this question.

"DKode" <dk****@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

please don't cross post against multiple newsgroups. You'll be lucky if
anyone responds to your thread.