Results 1 to 4 of 4

Thread: Singe Row to Multiple Row

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Apr 2013
    Posts
    2
    Rep Power
    0

    Single Row to Multiple Row

    I've read some of the other posts on this question, but I can't seem to figure out how to make this work for my scenario.
    I have a spreadsheet with multiple rows that looks like this.

    Title1 Desc1 Value1 Value1 Value2 Value2 Value3 Value3
    Title2 Desc2 Value1 Value1 Value2 Value2 Value3 Value3
    Title3 Desc3 Value1 Value1 Value2 Value2 Value3 Value3

    I need it to look like this . . .

    Title1 Desc1 Value1 Value1
    Title1 Desc1 Value2 Value2
    Title1 Desc1 Value3 Value3
    Title2 Desc2 Value1 Value1
    Title2 Desc2 Value2 Value2
    Title2 Desc2 Value3 Value3
    Title3 Desc3 Value1 Value1
    Title3 Desc3 Value2 Value2
    Title3 Desc3 Value3 Value3


    There are more than 3 "values" on each line, although not a fixed number. It could be 10, it could be 200. I basically need a new line for each pair of values for each Title/Desc.

    I may be making the question too complicate, but I think the visual of the spreadsheet before and after helps.

    Any assistance would be appreciated.
    Last edited by jerry2334; 04-17-2013 at 10:04 PM. Reason: word in title misspelled

Similar Threads

  1. Replies: 3
    Last Post: 05-23-2013, 11:17 PM
  2. Autofilling in VBA through the last row
    By jardenp in forum Excel Help
    Replies: 7
    Last Post: 03-29-2013, 09:46 PM
  3. Replies: 4
    Last Post: 03-22-2013, 01:47 PM
  4. Replies: 2
    Last Post: 03-05-2013, 07:34 AM
  5. Column to Row and Row to Column
    By lokvan in forum Excel Help
    Replies: 1
    Last Post: 11-30-2012, 09:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •