Re: Transpose rows to columns

Hi David
On Jan 13, 2004, at 10:12 AM, David Witham wrote:

> Hi,
>
> I have a query that returns data like this:
>
> cust_id cust_name month cost revenue margin
> 991234 ABC 2003-07-01 10 15 5
> 991234 ABC 2003-08-01 11 17 6
> 991234 ABC 2003-09-01 12 19 7
> 991235 XYZ 2003-07-01 13 21 8
> 991235 XYZ 2003-08-01 12 19 7
> 991235 XYZ 2003-09-01 11 17 6
>
> I want to turn it around so it displays like this:
>
> 991234,ABC,2003-07-01,10,15,5,2003-08-01,11,17,6,2003-09-01,12,19,7
> 991235,XYZ,2003-07-01,13,21,8,2003-08-01,12,19,7,2003-09-01,11,17,6
>
> (I've used commas to shorten the layout for the example)
>
> Does anyone have some ideas on how to do this?

I'd suggest looking at tablefunc in /contrib. It includes crosstab
functionality that you might find useful. I don't think it'll do
exactly what you describe here, but something quite similar.

Michael Glaesemann
grzm myrealbox com