Re: [GENERAL] pivoting data?

[Sim Zacks]

On 09/08/2011 03:15 PM, Joy Smith wrote: Hello Chris, yes that does seem to be a lot cleaner - though it does one thing that is not right -  ie) add to the previous data  insert into modvalues (parties,baloons,color,dayofpurchase,amountpur) values > ('1','big','red','1/2/2011',4); then the output looks like: baloons     color        jan first       jan second     jan third big             red            7 big             green                           14 big                 blue                           3 big                  red                            4 instead of looking like this(having big red only show up once with the new value under jan second): baloons     color        jan first       jan second     jan third big             red            7                     4 big             green                           14 big                 blue                           3 thank you for your help and ideas You'll want to group by baloons,color and probably take a sum of each of the case statements. Sim