1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Help with Macro in excel - Convert Rows to Repeating Columns

Discussion in 'Software Development' started by kamote, Sep 8, 2008.

Thread Status:
Not open for further replies.
  1. kamote

    kamote Thread Starter

    Joined:
    Sep 8, 2008
    Messages:
    1
    Hi, I'm new to macro. Hope you can help me with my problem. I've been stuck with this for a week with no result. :(

    I have this table:

    001 002 003 004
    111 115 119 123
    112 116 120 124
    113 117 121 125

    Let's say, the first row are the StoreID and all other digits below them are the ProductID

    I want to convert this table into something like this:
    001 111
    001 112
    001 113
    002 115
    002 116
    002 117
    003 119
    003 120
    003 121
    004 123
    004 124
    004 125

    I haven't made any macro before in MS Excel and this one is really getting the breath out of me.

    Hope you can help me please.. I'd really appreciate it.

    Thank you in advance!
     
  2. Ziggy1

    Ziggy1

    Joined:
    Jun 17, 2002
    Messages:
    2,551
    is this just a "one off" thing or do you have many sheets to convert? Because for one or a few sheets, it is not a lot of work to do manually...probably take a few minutes ( I 'll explain if you need)

    to automate I can do it, but I need to build some loops and references to refer to the columns and ranges to move to a new list...it's a bit of work.

    Please confirm also if it is only 4 columns, and or if the column count varies
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/748186

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice