Post reply

Pivot Result

  • January 7, 2010 at 1:56 pm

    #140542

    How do you pivot this set of data:

    FileDate Responding

    2009-11-02 00:00:00.000347627

    2009-11-01 00:00:00.000343016

    2009-10-31 00:00:00.000342413

    I need the data like:

    2009-11-02 00:00:00.000, 2009-11-01 00:00:00.000, 2009-10-31 00:00:00.000

    347627,343016, 342413

  • January 7, 2010 at 3:13 pm

    #1100540

    Do you need the output o be one column each or a list of comma separated values?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • January 7, 2010 at 3:15 pm

    #1100543

    I need the output to be a column.

    thank you 🙂

  • January 7, 2010 at 3:19 pm

    #1100550

    Does "a column" means ONE column including the comma separated list?

    If you need the data in a table with each value in its own column then please have a look at the link in my signature related to DynamicCrossTab.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • January 7, 2010 at 3:22 pm

    #1100554

    I need the data in a table with each value in its own column

    i will take at look at your link

    Thank you very much

Viewing 5 posts - 1 through 4 (of 4 total)

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