+ Reply to Thread
Results 1 to 6 of 6

Converting multiple columns to rows / Converting to Panel Data

  1. #1
    Registered User
    Join Date
    07-06-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    3

    Converting multiple columns to rows / Converting to Panel Data

    Dear all,

    I am currently struggling with a data format challenge. I have exported a large portion of data from Orbis into excel. However the data is not in “Panel Data” format, and I thus need to convert multiple columns into multiple rows. As the data set is rather large I can’t do this by hand – is anyone in here able to solve the challenge by code?

    Attached is a small example of the dataset. (The real dataset will include approximately 1700 companies and more key figures) The workbook includes 2 sheets. One with the original output from Orbis and a sheet where I have manually made an example of the desired data format.

    Your help would be very much appreciated.

    Best Regards,
    Stu

  2. #2
    Valued Forum Contributor Steffen Thomsen's Avatar
    Join Date
    10-15-2010
    Location
    Kolding, Denmark
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    953

    Re: Converting multiple columns to rows / Converting to Panel Data

    Hi,

    Try this.

    Open the workbook, and press the button on sheets2

  3. #3
    Registered User
    Join Date
    07-06-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Converting multiple columns to rows / Converting to Panel Data

    Hi Steffen,

    thanks a lot for your help, much appreciated!

    The code you have written works perfectly, however I need it to be able to handle more variables. I will try and alter it myself or else upload a new workbook,with all the included variables Or do you know if it is possible to make a dynamic code that could handle a not prespecified number of variables?

    Thanks again for your help,
    Stu

  4. #4
    Registered User
    Join Date
    04-13-2013
    Location
    GUNTUR
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Converting multiple columns to rows / Converting to Panel Data

    Hi

    I also need the help for this, my excel sheet uploaded with this message, could you plz do this
    Attached Files Attached Files
    Last edited by tulasiram; 04-13-2013 at 09:48 AM.

  5. #5
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Converting multiple columns to rows / Converting to Panel Data

    Tulasiram,

    Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  6. #6
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,445

    Re: Converting multiple columns to rows / Converting to Panel Data

    Stuart,
    Try this as an option

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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