Results 1 to 23 of 23

Macro to transpose multiple rows to a single column

Threaded View

  1. #1
    Registered User
    Join Date
    10-02-2014
    Location
    Brisbane, Australia
    MS-Off Ver
    2010
    Posts
    12

    Macro to transpose multiple rows to a single column

    Hi,

    Before:
    a1 b1 c1 d1 e1
    a2 b2 c2 d2 e2
    a3 __ c3 d3 __
    a4 b4 __ d4 e4

    After:
    a1
    b1
    c1
    d1
    e1
    a2
    b2
    c2
    d2
    e2
    a3

    c3
    d3


    a4
    etc etc

    The number of columns in my data is static at 25, but the number of rows can vary. If there are blank cells in the columns, it should leave a blank row in the transposed data, as per my example above.

    Can you please help me out here with a Macro that will reformat the data and paste it on a new sheet?

    Thanks
    Last edited by Gup; 10-02-2014 at 09:18 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Transpose Multiple Rows into a Single Row and Randomize in the Same Macro
    By bwalks in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-07-2014, 08:37 PM
  2. [SOLVED] Transpose multiple rows to single row
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-16-2014, 04:59 AM
  3. Transpose Multiple Rows into a Single Column
    By vnascimento in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-04-2013, 08:47 AM
  4. Replies: 5
    Last Post: 05-25-2013, 07:12 AM
  5. Macro to transpose one column into multiple rows over MANY lines of data?
    By mtc in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-24-2012, 10:34 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1