+ Reply to Thread
Results 1 to 3 of 3

Transpose Data/ Re-Arrange Columns and Rows

  1. 02-19-2012, 02:24 AM #1
    newbieexceldude
    newbieexceldude is offline
    Forum Contributor
    Join Date
    06-16-2008
    Posts
    115

    Transpose Data/ Re-Arrange Columns and Rows

    Hi Guys/Gals,

    I have a data set that I would like to re-arrange. I think looking at the attachment will be more helpful and less confusing than thrying to explain in detail.

    The Start tab is the original set of data. And the Desired Layout is what I'm hoping the result will be.

    I don't think the Transpose function will be appropriate here because I can not predict how large the data array will be (the actual spreadsheet is MUCH bigger). Also, I don't think that the Transpose function can copy the column labels down 10 rows like I need.

    If you don't have a specific answer, please let me know if it is possible to do this.

    Thanks in advance!
    Attached Files Attached Files
    Last edited by newbieexceldude; 02-19-2012 at 08:15 PM.
    Reply With QuoteRegister To Reply
  2. 02-19-2012, 03:45 AM #2
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Transpose Data/ Re-Arrange Columns and Rows

    Use this code - 
    Please Login or Register  to view this content.
    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]
    Reply With QuoteRegister To Reply
  3. 02-19-2012, 08:14 PM #3
    newbieexceldude
    newbieexceldude is offline
    Forum Contributor
    Join Date
    06-16-2008
    Posts
    115

    Re: Transpose Data/ Re-Arrange Columns and Rows

    Hi Arlette,

    This works brilliantly! I'm surprised at how it did everything I needed - even with a much larger data det.

    Thanks so much!

    Regards,
    Dee
    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)

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