+ Reply to Thread
Results 1 to 12 of 12

data rearrange help needed

  1. #1
    Registered User
    Join Date
    04-07-2021
    Location
    dhaka, bangladesh
    MS-Off Ver
    microsoft 365
    Posts
    5

    data rearrange help needed

    Hello all,

    I need to rearrange some data, like students have multiple subjects (max 4 subjects but some may have less subjects) and marks accordingly in rows. I want the data in column format. I add the excel file for your suggestion.

    data-setup-problem.PNG

    Thank you for your help in advance.
    Attached Files Attached Files
    Last edited by AliGW; 04-11-2021 at 01:49 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,175

    Re: data rearrange help needed

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new I will do it for you this time: https://www.excelguru.ca/forums/show...ge-help-needed)
    Ali


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

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite 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
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,534

    Re: data rearrange help needed

    If the following presentation is acceptable to you, then this can be accomplished with a pivot table.

    Excel 2016 (Windows) 32 bit
    E
    F
    G
    H
    10
    Sum of Marks Subject
    11
    Student ID English Math Science
    12
    1
    80
    78
    70
    13
    2
    80
    89
    14
    3
    90
    15
    4
    60
    85
    70
    16
    5
    80
    85
    Sheet: Sheet1

  4. #4
    Registered User
    Join Date
    04-07-2021
    Location
    dhaka, bangladesh
    MS-Off Ver
    microsoft 365
    Posts
    5

    Re: data rearrange help needed

    Thanks alansidman. I need subject names as data, not as pivot column.

    Looking for your kind help.

    Quote Originally Posted by alansidman View Post
    If the following presentation is acceptable to you, then this can be accomplished with a pivot table.

    Excel 2016 (Windows) 32 bit
    E
    F
    G
    H
    10
    Sum of Marks Subject
    11
    Student ID English Math Science
    12
    1
    80
    78
    70
    13
    2
    80
    89
    14
    3
    90
    15
    4
    60
    85
    70
    16
    5
    80
    85
    Sheet: Sheet1

  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2010
    Posts
    5,841

    Re: data rearrange help needed

    In E3 then copied down
    Please Login or Register  to view this content.
    In F3 then copied across
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by kvsrinivasamurthy; 04-08-2021 at 02:17 AM.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,876

    Re: data rearrange help needed

    manibd are the Student IDs in source data always in ascending sort order?
    Dave

  7. #7
    Registered User
    Join Date
    04-07-2021
    Location
    dhaka, bangladesh
    MS-Off Ver
    microsoft 365
    Posts
    5

    Re: data rearrange help needed

    It works.. many thanks.

    will be more happy if you tell me how to add one more column (like last exam marks)?

    kvsrinivasamurthy, thank you again

    Quote Originally Posted by kvsrinivasamurthy View Post
    In E3 then copied down
    Please Login or Register  to view this content.
    In F3 then copied across
    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    04-07-2021
    Location
    dhaka, bangladesh
    MS-Off Ver
    microsoft 365
    Posts
    5

    Re: data rearrange help needed

    Quote Originally Posted by FlameRetired View Post
    manibd are the Student IDs in source data always in ascending sort order?
    not all the time, but unique. fyi.

  9. #9
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    17,965

    Re: data rearrange help needed

    Please post file showing requirement from your post #7

  10. #10
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2010
    Posts
    5,841

    Re: data rearrange help needed

    Revised formula in G3 copied across

    Please Login or Register  to view this content.
    If you want add one more column change 3 in red font as 4 and so on...
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    04-07-2021
    Location
    dhaka, bangladesh
    MS-Off Ver
    microsoft 365
    Posts
    5

    Re: data rearrange help needed

    Quote Originally Posted by JohnTopley View Post
    Please post file showing requirement from your post #7
    many thanks for your reply.. i have got the solution from kvsrinivasamurthy

  12. #12
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2010
    Posts
    5,841

    Re: data rearrange help needed

    If problem solved mark the thread solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Code needed to rearrange data Base on 2 criterias
    By antonio32 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-16-2017, 03:36 PM
  2. [SOLVED] Code needed to rearrange data
    By antonio32 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-16-2017, 12:55 PM
  3. [SOLVED] Rearrange data
    By Financesolver in forum Excel General
    Replies: 3
    Last Post: 10-09-2015, 06:37 AM
  4. [SOLVED] Rearrange data
    By pdx-adm-trm01 in forum Excel General
    Replies: 1
    Last Post: 04-24-2014, 11:32 AM
  5. [SOLVED] Rearrange data with vba
    By ExcelMartin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-11-2013, 07:09 AM
  6. Rearrange Data
    By cutsygurl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2009, 12:44 PM
  7. rearrange data by day
    By Adent in forum Excel General
    Replies: 4
    Last Post: 07-31-2005, 04:26 PM

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