+ Reply to Thread
Results 1 to 4 of 4

Need to combine data

  1. #1
    Registered User
    Join Date
    03-10-2018
    Location
    TEXAS
    MS-Off Ver
    2010 Excel
    Posts
    9

    Need to combine data

    I am usually able to Google what I need to do in Excel and find an answer, but for this problem, I don't know what that which I'm trying to accomplish is called, so my searches have not been very successful. Please advise on what I should search or how I should go about solving this issue.

    In a workbook that contains multiple tabs. Each tab has a course subject by grade level. For example Tab 1- 6th grade math Tab 2- 6th grade English Tab 3 6th grade science and so on.
    On each tab there is a list of the students who qualify to take the Honors/Advanced section of that course.
    I also have a summary tab that combines all of the six grade courses, and I have sorted it by student name any student who qualifies for more than one honors course (they appear on more than one tab) has all of their courses listed together.
    I need to somehow shift this so that the student's name appears only once on the summary tab, with all of the course selections following the name on the same row.

    I have attached an example.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    27,600

    Re: Need to combine data

    Which version of Excel do you have? Please look at the splash screen when you launch it, and then update your user profile.

    The solution offered will depend on the version you have. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    Are you new to Power Query and don't know what to do with the code you've been given? Have a look here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    03-10-2018
    Location
    TEXAS
    MS-Off Ver
    2010 Excel
    Posts
    9

    Re: Need to combine data

    Done, thanks. It is Microsoft 2010.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    7,264

    Re: Need to combine data

    As modeled in the attached copy of the file,
    The student names are populated using: =IFERROR(IF(MATCH(0,INDEX(COUNTIF(D$4:D4,A$5:A$20),,),)>COUNTA(A$5:A$20),"",INDEX(A$5:A$20,MATCH(0,INDEX(COUNTIF(D$4:D4,A$5:A$20),,),))),"")
    The courses are populated using: =IF($D5="","",IFERROR(INDEX($B$5:$B$15,AGGREGATE(15,6,(ROW($A$5:$A$15)-ROW($A$4))/($A$5:$A$15=$D5),COLUMNS($A$1:A$1))),""))
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1