Results 1 to 5 of 5

Need Help Changing a Cell Into Multiple Rows

Threaded View

  1. #1
    Registered User
    Join Date
    07-23-2013
    Location
    satellite rsaentsr
    MS-Off Ver
    Excel 2010
    Posts
    10

    Need Help Changing a Cell Into Multiple Rows

    So I have two columns of data that are over 10,000 rows which I need help splitting into more rows. I will give an example of my problem and desired Solution. Basically just trying to retain info from column A (which has only one value) for every cell I break up in Column B. Some of the values in column B have 20+ values seperated by commas and im stuck, please help!

    Problem:

    A------B
    1000 200,205,207
    1001 280
    1008 200,207
    1102 203,210

    Desired Solution:

    A------B
    1000 200
    1000 205
    1000 207
    1001 280
    1008 200
    1008 207
    ......
    Last edited by shane01101; 07-23-2013 at 07:34 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 01-27-2012, 09:40 PM
  2. Changing Multiple Columns into Multiple Rows
    By Tester36 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-07-2011, 02:11 PM
  3. Replies: 0
    Last Post: 10-15-2010, 07:59 AM
  4. Changing cell fill colour based on date in cell - Multiple rows
    By ExcelNewb2010 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2010, 07:30 AM
  5. Replies: 9
    Last Post: 02-08-2008, 10:09 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