Re: Query
From: Carlos <miotromailcarlos_at_netscape.net>
Date: Mon, 15 Sep 2008 06:41:01 -0700 (PDT)
Message-ID: <9f048728-d00a-44a2-a920-a27e857b283d@d77g2000hsb.googlegroups.com>
Date: Mon, 15 Sep 2008 06:41:01 -0700 (PDT)
Message-ID: <9f048728-d00a-44a2-a920-a27e857b283d@d77g2000hsb.googlegroups.com>
On 15 sep, 15:31, Mtek <m..._at_mtekusa.com> wrote:
> Hi,
>
> I was wondering if I can display data like this:
>
> Original Data
> 01-JUN-08 Type1 Add 4308
> 01-JUN-08 Type1 Delete 4687
> 01-OCT-08 Type2 Delete 5545
> 01-OCT-08 Type2 Add 11801
>
> New Data
> 01-JUN-08 Type1 Add 4308 Delete 4687
> 01-OCT-08 Type2 Add 11801 Delete 5545
>
> I want all related records on the same line......
>
> Much thanks
Google for 'PIVOT TABLE'
HTH Cheers.
Carlos. Received on Mon Sep 15 2008 - 08:41:01 CDT