+ Reply to Thread
Results 1 to 6 of 6

Macro to traspose data

  1. #1
    Registered User
    Join Date
    10-13-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    3

    Macro to traspose data

    Hi
    I need a help of an expert;
    I want to transpose my data. Please see excel file. The original data is of 5 persons (in column) and working hours are recorded over the 35 days (day 1 to day 35 in rows). There are 35 entries for each persons.
    I want to do a longitudinal analysis. So I want to transpose data in such a way that each person is repeated 35 time one column, with day in next column (1-35), and working hours are give in front;

    For detail see attached excel sheet.

    Tx. AAC
    Attached Files Attached Files

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Macro to traspose data

    Try this sample, open the workbook, enable macros, select your data range (A3:AJ7 in this example), then click on the button
    Attached Files Attached Files
    Last edited by millz; 10-14-2013 at 01:09 AM.

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macro to traspose data

    Another option
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-13-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Macro to traspose data

    Quote Originally Posted by millz View Post
    Try this sample, open the workbook, enable macros, select your data range (A3:AJ7 in this example), then click on the button
    Thanks a lot. It worked very well. AAC

  5. #5
    Registered User
    Join Date
    10-13-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Macro to traspose data

    Quote Originally Posted by millz View Post
    Try this sample, open the workbook, enable macros, select your data range (A3:AJ7 in this example), then click on the button
    HI
    RE email below. There is a problem in this macro. Please see new data excel file. In this file of participant 1, there are blank entries on last five days. The macro does not account for those entries and data of participant 2, starts from the day 31 of the participant 1.

    It means, data of each participant not corresponds with days, if there are blank entries at the end of row.

    Please guide.
    AAC
    Attached Files Attached Files

  6. #6
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Macro to traspose data

    Hi aac1975,
    Try changing in the code, this line:
    Please Login or Register  to view this content.
    to this:
    Please Login or Register  to view this content.

+ 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] Data traspose to 4 groups
    By mathanraj76 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2013, 02:56 AM
  2. automatic macro with linking data in two workbooks, multiple row data to one row data
    By garfield8626 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2013, 01:47 PM
  3. cut information on rows and traspose paste to columns
    By Mengtzee in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 01-20-2012, 09:22 PM
  4. Macro to download monthly stock data and to refresh that data with the macro
    By Frankdude in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-23-2011, 08:38 PM
  5. [SOLVED] traspose a row by links
    By Stan Altshuller in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-05-2005, 02:06 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