+ Reply to Thread
Results 1 to 2 of 2

formula needed to copy same set of data from cells into a list

  1. #1
    Registered User
    Join Date
    06-04-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    59

    formula needed to copy same set of data from cells into a list

    Evening , I have a list of data in columns Q R S and i need to in between each line insert the data from columns
    D E F underneath and then underneath that the data from G H I


    so bascially i have a list at the moment like this


    Match Odds Result
    Motherwell v Inverness0-0 DRAW<D5> 9.0 LOSE
    Kilmarnock v Mothewell 0-0 DRAW<D5> 13.0 Win
    Dortmund v Hamburg 0-0 DRAW<D5> 9.0 LOSE

    BUt i need it to be like this

    Match Odds Result
    Motherwell v Inverness0-0 DRAW<D5> 9.0 LOSE
    1-1 DRAW 8.0 LOSE
    2-2 DRAW 19.0 LOSE
    3-3 DRAW 80.0 LOSE
    4-4 DRAW 750.0 LOSE

    Kilmarnock v Mothewell 0-0 DRAW<D5> 13.0 Win
    1-1 DRAW 8.0 LOSE
    2-2 DRAW 19.0 LOSE
    3-3 DRAW 80.0 LOSE
    4-4 DRAW 750.0 LOSE

    Dortmund v Hamburg 0-0 DRAW<D5> 9.0 LOSE
    1-1 DRAW 8.0 LOSE
    2-2 DRAW 19.0 LOSE
    3-3 DRAW 80.0 LOSE
    4-4 DRAW 750.0 LOSE


    There is 2 sheets in total , 1 i need to inc 1-1 draw as above and the other sheet
    to be exc the 1-1 draw .
    I have attached an example of what i am trying to achieve .
    would appreciate any help anybody can offer

    Regards Matt
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: formula needed to copy same set of data from cells into a list

    Hi Matt,

    Gone through both the sheets of the attachment and both are appearing as same.. i.e., the table on the right side looks same. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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