+ Reply to Thread
Results 1 to 5 of 5

VBA Macro to transpose the rows to columns

  1. 07-03-2018, 06:27 AM #1
    skallamp
    skallamp is offline
    Registered User
    Join Date
    06-02-2014
    Posts
    1

    VBA Macro to transpose the rows to columns

    Can any one please help me to get a excel vba macro to transpose the excel data from rows to column?

    have
    ~~~~~
    Mendiola, Laura
    802 S Loop 499
    Harlingen, TX 78550
    Teng, Li
    1601 W Hebron Pkwy
    Carrollton, TX 75010
    Suarez, Cerena
    7430 Remcon Cir Bldg A
    El Paso, TX 79912

    Want
    ~~~~~
    Mendiola, Laura 802 S Loop 499 Harlingen, TX 78550
    Teng, Li 1601 W Hebron Pkwy Carrollton, TX 75010
    Suarez, Cerena 7430 Remcon Cir Bldg A El Paso, TX 79912

    Thanks,
    +Sathyan
    Reply With QuoteRegister To Reply
  2. 07-03-2018, 07:14 AM #2
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: VBA Macro to transpose the rows to columns

    Try:
    Please Login or Register  to view this content.
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
  3. 07-03-2018, 07:17 AM #3
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: VBA Macro to transpose the rows to columns

    Hi skallamp

    Welcome to the forum...Here's one way...
    Please Login or Register  to view this content.
    Edit...My bad...perhaps misunderstood...Above is to have all in same column...
    Below is for separate columns...
    Please Login or Register  to view this content.
    Last edited by Sintek; 07-03-2018 at 07:27 AM.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  4. 07-03-2018, 07:36 AM #4
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: VBA Macro to transpose the rows to columns

    I was also not sure if the output shall go into one column or 3 columns.
    In thread title there was plural form, while in first sentence of post text: singular.
    Let's wait for skallamp's comment :-)
    Reply With QuoteRegister To Reply
  5. 07-03-2018, 09:55 AM #5
    MickG
    MickG is offline
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: VBA Macro to transpose the rows to columns

    Another option, results start "E1"
    Please Login or Register  to view this content.
    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. [SOLVED] Need a Macro to Transpose and Combine like Values from rows to columns
    By Isara-NJ in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-27-2017, 08:38 AM
  2. VBA Macro to Transpose Columns to Rows AND Concatenate Afterwards
    By ljanak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2013, 03:16 PM
  3. Macro to transpose rows to columns
    By escodc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2013, 03:15 PM
  4. [SOLVED] Macro to Transpose variable columns into rows
    By Awalgaonkar in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-18-2013, 01:11 PM
  5. [SOLVED] Macro to Transpose data in rows to columns
    By Shanthuday in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2012, 08:00 AM
  6. [SOLVED] Macro to Transpose Columns Into Rows
    By boldcode in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2011, 04:44 PM
  7. Macro to transpose a set of rows to columns
    By romanzy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2010, 06:45 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