Post reply

Display columns as rows

  • February 9, 2009 at 8:14 pm

    #155254

    I'm mainly having trouble with finding out what the term for the following is called so I can't google an answer. A quick push in the right direction would be great.

    Basically I have data like so:

    01-Jan-2000 1

    01-Jan-2000 2

    02-Jan-2000 1

    02-Jan-2000 3

    And I'd like to perform some aggregate calculations on the non-date-data and then display the date as the column and the aggregates below that.

    Is this possible without resorting to horrible string concats etc?

    Much thanks

  • February 9, 2009 at 10:25 pm

    #940966

    You want to pivot the data. Search for that.

  • February 9, 2009 at 11:16 pm

    #940985

    Great, thanks a lot. That looks like what I'm looking for 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply