Results 1 to 2 of 2
  1. #1
    Join Date
    May 2011
    Posts
    7

    Unanswered: Turning Multiple Rows into multiple columns

    Hi,

    I have a table that looks like below

    ID Date Job
    1 09/02/2011 Job A
    2 11/02/2011 Job A
    3 01/03/2011 Job B
    4 05/03/2011 Job B

    I want it to look as below:

    Job Date1 Date2
    Job A 09/02/2011 11/02/2011
    Job B 01/03/2011 05/03/2011

    I am fairly new to access so a step by step would be great.

    Any help would be massively appreciated.

  2. #2
    Join Date
    Oct 2009
    Posts
    340
    That is the crosstab feature.
    www CahabaData com

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •