+ Reply to Thread
Results 1 to 2 of 2

Duplicating Specific Rows in Spreadsheet

  1. #1
    Registered User
    Join Date
    06-29-2014
    Location
    Kingsville, Texas
    MS-Off Ver
    2013
    Posts
    0

    Duplicating Specific Rows in Spreadsheet

    Hi All,
    I'm trying to duplicate only specific rows in a spreadsheet. In my data, some rows have the same ID number, meaning they "match." Those that don't have a matching ID number need to be duplicated. For example:

    ID Number Data
    1 aaa
    2 bbb
    3 ccc
    3 ddd
    4 eee
    5 fff
    5 ggg

    Needs to look like:

    ID Number Data
    1 aaa
    1 aaa
    2 bbb
    2 bbb
    3 ccc
    3 ddd
    4 eee
    4 eee
    5 fff
    5 ggg

    Any suggestions would be great. Thanks!

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Duplicating Specific Rows in Spreadsheet

    Hi,

    One way.
    In C2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    copy down and across to D8

    Then copy C2:D8, paste it as values in A9 and then sort A1:B11 with column A as key 1 ascending and column B as key 2 ascending.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. [SOLVED] Extracting specific rows from a large spreadsheet
    By MelindaCapri in forum Excel General
    Replies: 5
    Last Post: 09-06-2012, 11:44 AM
  2. Duplicating spreadsheet across a year
    By pepsi in forum Excel General
    Replies: 1
    Last Post: 04-27-2012, 08:44 AM
  3. Excel 2007 : Duplicating specific rows
    By jpham in forum Excel General
    Replies: 4
    Last Post: 06-16-2011, 12:50 AM
  4. Replies: 1
    Last Post: 07-30-2010, 10:01 PM
  5. duplicating a spreadsheet
    By Gavin in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-04-2005, 09:06 AM

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