+ Reply to Thread
Results 1 to 7 of 7

data sorting

  1. 01-21-2019, 01:26 PM #1
    nab92002
    nab92002 is offline
    Registered User
    Join Date
    11-17-2018
    Location
    pakistan
    MS-Off Ver
    office 2016
    Posts
    32

    data sorting

    HI,

    I have to sort data vertically as its currently horizontal. Transpose does not works as it changes a lot of the data set. Please take a look of this file and help me out in sorting this data vertically.


    Thanks in anticipation.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-21-2019, 01:29 PM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: data sorting

    Have you tried loading it into Power Query and using the Transpose feature? You haven't really said how you want it arranging.
    Last edited by AliGW; 01-21-2019 at 01:41 PM.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 01-21-2019, 01:38 PM #3
    nab92002
    nab92002 is offline
    Registered User
    Join Date
    11-17-2018
    Location
    pakistan
    MS-Off Ver
    office 2016
    Posts
    32

    Re: data sorting

    can u help me on this, i dont know how to do it. The first sheet has data horizontally. wheres, as for analysis purpose i need data to be vertical as shown in the sheet 2 of the file.
    Last edited by nab92002; 01-21-2019 at 01:40 PM.
    Reply With QuoteRegister To Reply
  4. 01-21-2019, 01:40 PM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: data sorting

    Well, I could, but you haven't really made it clear exactly how you are hoping it will look. Can you tell me that?
    Reply With QuoteRegister To Reply
  5. 01-21-2019, 01:44 PM #5
    nab92002
    nab92002 is offline
    Registered User
    Join Date
    11-17-2018
    Location
    pakistan
    MS-Off Ver
    office 2016
    Posts
    32

    Re: data sorting

    please have a look at sheet number two in the same file Named as required shape c3 is name of the area the c5 to h5 has the name of variables and then b6 has years, when one area ends the other area starts just beneath it like c39 and so on.
    Reply With QuoteRegister To Reply
  6. 01-21-2019, 01:45 PM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: data sorting

    I've just seen the required layout hidden on another tab in your workbook! I will have a look in a short while.
    Reply With QuoteRegister To Reply
  7. 01-21-2019, 01:45 PM #7
    nab92002
    nab92002 is offline
    Registered User
    Join Date
    11-17-2018
    Location
    pakistan
    MS-Off Ver
    office 2016
    Posts
    32

    Re: data sorting

    thanks for your help,
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. HELP! Pivot sorting by data that is no longer there. Trying to clean up the sorting option
    By DDrimmer in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-16-2015, 01:04 PM
  2. Sorting values in charts without sorting data in table source (excel 2013)
    By boboivan in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-24-2014, 11:27 AM
  3. Macro-need help sorting data to other worksheets/update as new data is entered.
    By Beefy1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2014, 12:09 PM
  4. [SOLVED] Data Analysis: Comparing 3 columns, sorting, removing unique values, display data
    By kmills2626 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-14-2013, 07:27 AM
  5. Sorting 2 data ranges by comparing one column in each and sorting to match
    By MDKsmiffy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-17-2013, 03:30 PM
  6. After applying a Data Filter and sorting the data, how can you revert back to original?
    By yumyumdimsum in forum Excel General
    Replies: 3
    Last Post: 12-20-2012, 06:16 AM
  7. Sorting, finding dulicates, moving one data element up, deleting original data
    By rickwtx in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-13-2011, 07:32 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1