Results 1 to 6 of 6
  1. #1
    Biplab1985 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    6

    Transpose Columns To Rows

    Hi,



    I need help to move Couple of Columns only to Rows result in order to have a tale prepared.

    Headers - ID Country Customer Brewer Brand SubBrand OuterPackage InnerPackage ContainerVolume SKU Year Month Sales Sales_Promo Units Units_Promo Volume Volume_Promo
    Value - 306 BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 Apr 64 0 10 0 19.7 0

    I need only couple of Headers to come to rows field like below

    Measure Country Customer Brewer Brand SubBrand OuterPackage InnerPackage ContainerVolume SKU Year Apr
    Sales BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 64
    Sales_Promo BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 0
    Units BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 10
    Units_Promo BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 0
    Volume BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 19.7
    Volume_Promo BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 0

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    have you tried a Crosstab query?
    (instead as values in the matrix, use the FIRST)

  3. #3
    Biplab1985 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    6
    I tried but did get the result. Could you instruct?

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    use a query wizard to build the crosstab.
    during the guide, at the end FIELDS, select the function FIRST.

  5. #5
    Biplab1985 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    6
    I have couple of challenges doing that
    1. I need all the Sales,Sales_Promo,Units,Units_Promo,Volume,Volume_ Promo under Row header Measure
    2. The Value of the Measure should be below Month Variable. I tried doing using access wizard but getting different output.

  6. #6
    Biplab1985 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    6
    Any Input?

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

Similar Threads

  1. Transpose rows x columns
    By mumaan in forum Access
    Replies: 1
    Last Post: 05-20-2015, 08:01 AM
  2. Replies: 4
    Last Post: 02-25-2014, 01:09 AM
  3. Replies: 12
    Last Post: 07-31-2013, 01:29 PM
  4. Query to transpose Data in Columns to Rows
    By ace1259 in forum Access
    Replies: 2
    Last Post: 04-10-2012, 01:49 PM
  5. Rows into Columns
    By chrisdavis in forum Programming
    Replies: 16
    Last Post: 12-22-2011, 01:58 PM

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