+ Reply to Thread
Results 1 to 5 of 5

Transpose every 220 rows horizontally

  1. #1
    Registered User
    Join Date
    11-25-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    31

    Transpose every 220 rows horizontally

    Hi,

    This seems like a quick solution, I have tried modifying the macros of other similar problems individuals have had but my macros coding is not up to par.

    In the data below I have a list of data that repeats the same format every 220 rows with data up to column AI, and this goes on for thousands of rows. Rather than individually selecting the range of 220rows and columns and transposing it horizontally, I would like a macros that goes through the list transposing up until the end.

    I have attached a sample of the data. In the worksheet "What I Need" it shows what I would like to do with this data.

    Thank you,

    Haseeb
    Attached Files Attached Files
    Last edited by hkayani08; 02-10-2012 at 02:45 PM. Reason: solved

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Transpose every 220 rows horizontally

    Try this.

    Please Login or Register  to view this content.
    Martin

  3. #3
    Registered User
    Join Date
    11-25-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    31

    Thumbs up Re: Transpose every 220 rows horizontally

    Thanks worked like a charm.

    Easy to modify too.

  4. #4
    Valued Forum Contributor
    Join Date
    10-21-2011
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    513

    Re: Transpose every 220 rows horizontally

    Hi,

    I was just trying to learn something from this post:

    How does Step work?

    why use 219 but not 220 in cells(N + 219)

    thanks

  5. #5
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Transpose every 220 rows horizontally

    The range of cells to be copied has 220 rows. When N = 1 then this expression describes the range 1-220. The next value in the loop is N = 221 (step 220) so the expression then describes rows 221 to 440 etc.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1