+ Reply to Thread
Results 1 to 3 of 3

Sorting data from rows (multiple sheets) in columns (one sheet)

  1. #1
    Registered User
    Join Date
    03-05-2015
    Location
    Podgorica
    MS-Off Ver
    OFFICE 2007
    Posts
    2

    Sorting data from rows (multiple sheets) in columns (one sheet)

    Hi All,

    In order to conduct an event study, I have to sort company’s data in specific manner.
    Excel file consists of 9 sheets, each sheet has data of same companies, but for different years. The data is in rows and is related to company’s symbol, date and price on specific date. The following table shows the data for 3 of 921 company’s from the sample, which is derived from the sheet related to the year 2002.

    ZOT SM Equity
    Date 1/3/2002 1/4/2002
    PX_LAST 4.8717 4.7875

    ZON PL Equity
    Date 1/3/2002 1/4/2002
    PX_LAST 4.0601 4.0212

    ZIL2 GR Equity
    Date 1/3/2002 1/4/2002
    PX_LAST 1.75 1.676




    I have to gather all data from 9 sheets (year 2002-2010) in one sheet and sort it into columns. This means data of one company for all years, then second company data for all years etc. For example:

    Symbol Date PX_LAST
    ZOT SM Equity 1/2/2002 4.7565
    ZOT SM Equity 1/3/2002 4.8717
    ZOT SM Equity 1/4/2003 4.7875
    ZOT SM Equity 1/5/2003 4.7875
    ZOT SM Equity 1/6/2004 4.7875
    ZOT SM Equity 1/7/2004 4.7875
    ZOT SM Equity 1/8/2005 4.7875
    ZOT SM Equity 1/9/2005 4.7875
    ZON PL Equity 1/2/2002 3.8996
    ZON PL Equity 1/3/2002 4.0601
    ZON PL Equity 1/4/2003 4.0212
    ZON PL Equity 1/5/2003 3.9726
    ZON PL Equity 1/6/2004 3.9385
    ZON PL Equity 1/7/2004 3.8996
    ZON PL Equity 1/8/2005 3.8899
    ZON PL Equity 1/9/2005 3.8899
    ZIL2 GR Equity 1/2/2002 1.833
    ZIL2 GR Equity 1/3/2002 1.75
    ZIL2 GR Equity 1/4/2003 1.676
    ZIL2 GR Equity 1/5/2003 1.692
    ZIL2 GR Equity 1/6/2004 1.692
    ZIL2 GR Equity 1/7/2004 1.717
    ZIL2 GR Equity 1/8/2005 1.717
    ZIL2 GR Equity 1/9/2005 1.717

    Is this possible? I would appreciate your help, thank you all for your time and consideration.

    All the best,
    Ana

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Sorting data from rows (multiple sheets) in columns (one sheet)

    Certainly possible.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    03-05-2015
    Location
    Podgorica
    MS-Off Ver
    OFFICE 2007
    Posts
    2

    Re: Sorting data from rows (multiple sheets) in columns (one sheet)

    Thanks a lot on your fast response! I've managed to do it myself and now I have the database ready for the analysis.

    Nevertheless I am very grateful on your good will to help!!

    Sorry for replying just now (wasn't able earlier).

    All the best,
    Ana

+ 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. Simultaneously sorting data in ranges on multiple sheets based on criteria on one sheet
    By Chris Greensmith in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-10-2015, 06:40 AM
  2. [SOLVED] Sorting data from a master sheet to multiple sheets depending on values in a given column
    By kodos10 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-30-2013, 05:46 AM
  3. Help needed sorting multiple columns/rows of data
    By missyhol in forum Excel General
    Replies: 0
    Last Post: 12-21-2012, 10:47 AM
  4. Macro to copy 3 columns of data from multiple sheets into 3 columns on 1 sheet
    By bballdcm2007 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-15-2012, 04:37 PM
  5. [SOLVED] Want to combine columns in rows where data exists from multiple sheets into one
    By bugmenot in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2009, 08:27 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