Results 1 to 4 of 4
  1. #1
    pal01 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2020
    Posts
    2

    Post Can I write query to rearrange table data so that values of one column become column headers?


    I have a table where users will input daily values for set of ID tags. The table is structured like this:
    DATE ID VALUE
    1-1-2020 A 1
    1-1-2020 B 2
    1-1-2020 C 3
    1-2-2020 A 4
    1-2-2020 B 5
    1-2-2020 C 6

    For other users to work with data easier, they would like a query that would have the ID tags as the column headers and the date column remains, structured like this:
    DATE A B C
    1-1-2020 1 2 3
    1-2-2020 4 5 6

    Is it possible to create a query that can do this for me?

    Thanks for any help or point in the right direction. First post, happy to join a great community.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Play with the crosstab query wizard.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    pal01 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2020
    Posts
    2
    Thanks! I didn't know about this feature. Was able to transform data using Crosstab Query Wizard.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem, and welcome to the site by the way!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 12-29-2015, 03:25 PM
  2. Replies: 14
    Last Post: 07-13-2015, 12:47 PM
  3. Replies: 4
    Last Post: 06-22-2015, 06:47 AM
  4. Renaming Column Headers in Pivot Table
    By excellenthelp in forum Access
    Replies: 1
    Last Post: 10-24-2014, 01:50 PM
  5. Replies: 2
    Last Post: 06-17-2014, 09:15 AM

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
  •  
Other Forums: Microsoft Office Forums