Results 1 to 3 of 3

VBA to convert data in corresponding column to multiple rows

Threaded View

  1. 08-12-2013, 09:54 AM #1
    alexxgalaxy
    alexxgalaxy is offline
    Registered User
    Join Date
    09-16-2011
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    52

    Question VBA to convert data in corresponding column to multiple rows

    I have two columns of data that I would like to transpose them to rows as follows. Column A contains repeated data which the number of occurrence varies while the data in column B is unique. I've attached an excel spreadsheet, which shows the data in column A & B from which I would like to transpose to the data in column F to Y. Can anyone help do it with VBA? Many thanks!

    A B
    1 001-011102 A00120395
    2 033-018835 A00123014
    3 033-018835 A00123016
    4 033-018835 A00123019
    5 033-019060 A00126362

    ↓

    F G H
    2 001-011102 A00120395
    3 033-018835 A00123014 A00123016 A00123019
    4 033-019060 A00126362
    Attached Files Attached Files
    Last edited by alexxgalaxy; 08-12-2013 at 07:20 PM.
    Reply With QuoteRegister To Reply
« 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. One large column of data - convert it to rows?
    By l.josie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-23-2013, 01:21 PM
  2. Single row with multiple values in one column - convert to multiple rows?
    By jdtoronto in forum Excel General
    Replies: 0
    Last Post: 09-26-2012, 10:33 AM
  3. Convert multiple rows to one single column
    By Rashme in forum Excel General
    Replies: 2
    Last Post: 09-12-2012, 03:20 PM
  4. To convert data in multiple sets of columns to multiple rows
    By Dhanya_nair in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2012, 02:49 PM
  5. How can I convert a data from multiple rows into 1 column?
    By yudi_lks in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-30-2005, 12:07 AM

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