+ Reply to Thread
Results 1 to 2 of 2

Split data from a row into multiple rows

  1. #1
    Forum Contributor
    Join Date
    01-13-2016
    Location
    Sheffield, England
    MS-Off Ver
    2016
    Posts
    216

    Split data from a row into multiple rows

    Hi All,

    I have a problem that I have beating my head about for some time now. I am hoping that one of you helpful lot can help resolve it.
    I have a workbook with several sheets within it. The sheets all pull info from a sheet named 'Input'.
    The problem I have is that if an order has several different products on it I need to separate the products on to different rows but with all the rest of the data being the same. This is probably made easier to understand with a screenshot.Doc1.pdf
    As you can see on the attached under the headings 'xp10, smart windows, smart t&t windows, fixed frames, shaped frames & adeco doors' there is a number.
    What I require is that these are all put on to separate rows but with all the rest of the data from the row included.

    I hope someone can help.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,891

    Re: Split data from a row into multiple rows

    Instead of that, please post a sample Excel sheet!!! Your pdf is non-editable.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA: Split cell values into multiple rows and keep other data
    By kishansingh027 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2018, 09:04 PM
  2. [SOLVED] Formula to split data from one cell into multiple rows
    By tchock in forum Excel General
    Replies: 6
    Last Post: 01-21-2018, 10:11 AM
  3. [SOLVED] Is there way to split data into multiple rows?
    By Squibfish in forum Excel General
    Replies: 6
    Last Post: 07-22-2015, 12:12 PM
  4. Split Row Into Multiple Rows based on Count of Data
    By bchilme in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2014, 05:58 PM
  5. I want to split row data to multiple rows
    By SumitM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2013, 05:37 AM
  6. [SOLVED] Split a cell of data into multiple rows
    By otterandrews in forum Excel General
    Replies: 4
    Last Post: 03-24-2013, 11:59 PM
  7. Split a row of data into multiple rows
    By chuckyfang in forum Excel General
    Replies: 2
    Last Post: 03-19-2013, 06:13 PM

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