List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:July 16 2006 4:42am
Subject:Re: Pivoting the result set.
View as plain text  
>Would like for the results to become pivoted and be transposed to look
>like this.

There's a little step-by-step for this at 
http://www.artfulsoftware.com/queries.php under 'Pivot tables', 'Group 
column statistics in rows'.

PB

-----

Ow Mun Heng wrote:
> Hi, 
>
> I have a query that comes out like this.
>
> Program   Status  Param1  Param2  Param3  Param4  Param5
> A                      1           1.1           2.2         3.3
> 4.4           5.5
> B                      2           2.2          3.3          4.4
> 5.5           6.6
> C                      3           3.3           4.4         5.5
> 6.6          7.7
>
> Would like for the results to become pivoted and be transposed to look
> like this.
>
> Program	 A         B       C
> Status          1         2       3
> Param1        1.1     2.2   3.3
> Param2        2.2     3.3    4.4
> param3        3,3      4.4    5.5
> Param4         4.4      5.5    6.6
> Param5         5.5      6.6     7.7
>
> Thanks
>
>   


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.1/389 - Release Date: 7/14/2006

Thread
Pivoting the result set.Ow Mun Heng16 Jul
  • Re: Pivoting the result set.Peter Brawley16 Jul