Results 1 to 3 of 3

Thread: How to get Report

  1. #1
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007

    Post How to get Report



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Sir,
    we have a following data table.
    GRADE VALUE
    304 5
    JT 6
    304 8
    316 9
    304 4
    316 11
    304 17
    JT 40
    316 35

    My question is how to get the data from the above table like below.
    304 316
    5 9
    8 11
    4 35

  2. #2
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    You are missing a third column, I presume this is Test number.

    Add a third column, call it test and on c2 =COUNTIF(A$2:A2,A2) copy this down

    Create a pivot table Row (test), Column (grade) and Sum(Value)

  3. #3
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Dear Sir,

    Thanks for resolve the issue.

    Regrds,
    sambit

Posting Permissions

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