Re: vertical to horizonal

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 6 May 1999 10:35:03 +0200
Message-ID: <7grkaq$5l4$1@hermes.is.co.za>

Joerg Leute wrote in message <7gpte0$23j7$1_at_news.lf.net>...

>Hi everybody. I got a real tricky question here. <snipped>

Called pivoting. You want to display the rows as columns and the columns as rows - i.e. vertical to horizontal as you mentioned in the topic of the posting.

The trick is to create a pivot table to perform the pivoting of rows to columns. I have posted about how to do it before in this newsgroup. Once in '97 and once in '98. Damned if I'm going to do it again in '99! :-)

Please look up these postings on DejaNews using the following URL: --cut--
http://www.dejanews.com/dnquery.xp?ST=PS&QRY=pivot+table&defaultOp=AND&DBS=1 &format=terse&showsort=score&maxhits=25&LNG=english&subjects=&groups=comp.da tabases.oracle.server&authors=Billy+Verreynne&fromdate=&todate= --cut--
(power search on DejaNews with my name as the author, comp.databases.oracle.server as the forum and "pivot table" as the text to search for)

If you have any questions about this pivoting technique, please shout.

regards,
Billy Received on Thu May 06 1999 - 03:35:03 CDT