+ Reply to Thread
Results 1 to 9 of 9

Transpose vertical data into horizontal records vba

  1. 05-27-2014, 02:06 AM #1
    nolans18
    nolans18 is offline
    Registered User
    Join Date
    07-17-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    9

    Unhappy Transpose vertical data into horizontal records vba

    Hi all,

    Can someone please help me with the following? Basically, I have a large amount of data that is generated in a vertical format on the sheet named 'RawData' which needs to be transposed into horizontal records on the sheet named "What I Want". I found a soultion to copy and transpose the data but this is quite tedious as the data keeps expanding.

    Could someone please help me with setting up a macro that would automate this task? I have tried so many solutions but none worked so far

    Thanks for all you support!!!

    Report.xlsx
    (._.) ( l: ) ( .-. ) ( :l ) (._.)
    Reply With QuoteRegister To Reply
  2. 05-27-2014, 04:28 AM #2
    poorcloud
    poorcloud is offline
    Registered User
    Join Date
    09-04-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Transpose vertical data into horizontal records vba

    Not the most elegant solution but i think this works!

    You need to change the worksheet"test" into some sheet that you actually use though.

    Let me know if it works for you

    Please Login or Register  to view this content.
    Last edited by poorcloud; 05-27-2014 at 04:38 AM.
    Reply With QuoteRegister To Reply
  3. 05-27-2014, 04:34 AM #3
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Transpose vertical data into horizontal records vba

    Try the attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 05-27-2014, 04:34 AM #4
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Transpose vertical data into horizontal records vba

    Poorcloud,
    Please wrap up your code with code tags as per forum's rule.
    Reply With QuoteRegister To Reply
  5. 05-27-2014, 04:47 AM #5
    apo
    apo is offline
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: Transpose vertical data into horizontal records vba

    Heres another..

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 05-27-2014, 05:23 AM #6
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Transpose vertical data into horizontal records vba


    Hi !

    If less than 66K lines, Application.Transpose do well the job !

    In case of more than 65K lines, using a Windows object like a listbox for example
    avoids gas factory For … Next processing !

    Regards !
    Last edited by Marc L; 05-27-2014 at 06:08 AM.
    Reply With QuoteRegister To Reply
  7. 05-27-2014, 05:51 AM #7
    David A Coop
    David A Coop is offline
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Transpose vertical data into horizontal records vba

    Hi nolans18,

    Transpose Macro for nolans18.xlsm

    Yet another macro!

    I have created a new sheet called OUTPUT instead of "What I Want". Note that I haven't addressed the formatting.

    Please Login or Register  to view this content.
    I hope this helps, please let me know!

    Regards,

    David

    If this has been of assistance, please advise. A little thanks goes a long way.
    - Please click on the *Add Reputation button at the bottom of helpful responses.

    Please mark your thread as SOLVED:
    - Click Thread Tools above your first post, select "Mark your thread as Solved".

    When you reply please make it clear WHO you are responding to by mentioning their name.
    Reply With QuoteRegister To Reply
  8. 05-27-2014, 07:09 PM #8
    nolans18
    nolans18 is offline
    Registered User
    Join Date
    07-17-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    9

    Thumbs up Re: Transpose vertical data into horizontal records vba

    Brilliant work guys!! This forum rocks and thank you for all your support..much appreciated
    Reply With QuoteRegister To Reply
  9. 05-27-2014, 08:50 PM #9
    David A Coop
    David A Coop is offline
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Transpose vertical data into horizontal records vba

    Quote Originally Posted by nolans18 View Post
    Brilliant work guys!! This forum rocks and thank you for all your support..much appreciated
    You're welcome mate! Thanks for the encouragement.

    Regards,

    David
    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. Excel macro to transpose horizontal data to vertical
    By LittleFry in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-01-2016, 05:54 AM
  2. [SOLVED] Data transpose (from vertical input to Horizontal output)
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2013, 11:12 AM
  3. Transpose Vertical Data to Horizontal
    By Randu555 in forum Excel General
    Replies: 5
    Last Post: 04-18-2013, 05:05 PM
  4. Convert a portion of data from horizontal to vertical but not all (cant use transpose)
    By flyinhigh873 in forum Excel General
    Replies: 1
    Last Post: 10-03-2012, 02:46 PM
  5. transpose data from horizontal to vertical in a specific column
    By elaine in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2006, 12:10 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1