+ Reply to Thread
Results 1 to 5 of 5

Duplicate cell data by a fixed value

  1. 03-01-2016, 10:31 AM #1
    Pooleyy
    Pooleyy is offline
    Registered User
    Join Date
    03-01-2016
    Location
    Birmingham, England
    MS-Off Ver
    365
    Posts
    1

    Duplicate cell data by a fixed value

    Hi All,

    I have a list of unique data in Excel. I want to take this data and basically duplicate it more than once (specifically 7 times)

    E.G.

    My list:

    1000A177
    1035A654
    1110A223

    I want x7 of the above values, still in one column and seperate cells, like this:

    100A177
    100A177
    100A177
    100A177
    100A177
    100A177
    100A177
    1035A654
    1035A654
    1035A654
    1035A654
    1035A654
    1035A654
    1035A654
    1110A223
    1110A223
    1110A223
    1110A223
    1110A223
    1110A223
    1110A223

    I have a lot of data, it's too much to do individually.
    Any ideas?

    Best Regards,
    Sam
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-01-2016, 10:47 AM #2
    Richard Buttrey
    Richard Buttrey is offline
    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: Duplicate cell data by a fixed value

    Hi, and welcome to the forum

    Assuming the original data of n rows starts in A1 then in B1 copied down n x 7 rows

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    if you start the range in a different row, say row 10 for instance then just adjust the INT() bit. e.g.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Last edited by Richard Buttrey; 03-01-2016 at 10:54 AM.
    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 With QuoteRegister To Reply
  3. 03-01-2016, 10:59 AM #3
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Duplicate cell data by a fixed value

    Enter formula in C2 and copy down

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Please see attached file:

    v A B C
    1 Values Times to repeat Result
    2 1000A177 7 1000A177
    3 1035A654 1000A177
    4 1110A223 1000A177
    5 1110A225 1000A177
    6 1110A226 1000A177
    7 1110A227 1000A177
    8 1300A065 1000A177
    9 1305A043 1035A654
    10 1588A063 1035A654
    11 1632A003 1035A654
    12 1632A038 1035A654
    13 4670A234 1035A654
    14 6400A027 1035A654
    15 7805A089 1035A654
    16 8330A005 1110A223
    17 8330A020 1110A223
    18 8541A219 1110A223
    19 MB302665 1110A223
    20 MB888461 1110A223
    21 MD082347 1110A223
    22 MD345074 1110A223
    Attached Files Attached Files
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  4. 03-01-2016, 11:49 AM #4
    Czeslaw
    Czeslaw is offline
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,429

    Re: Duplicate cell data by a fixed value

    I propose the following formula.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 03-01-2016, 11:51 AM #5
    Czeslaw
    Czeslaw is offline
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,429

    Re: Duplicate cell data by a fixed value

    I propose the following formula.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to combine multiple rows of duplicate data and one cell of unique data
    By scpg13 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-25-2013, 10:26 PM
  2. [SOLVED] Fixed Cell Reference Minus a Fixed Number
    By juddykong in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-03-2013, 03:25 PM
  3. [SOLVED] Delete duplicate data column A and merge data in colum B into single cell
    By GAIMoore in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-19-2013, 04:17 PM
  4. how do I copy data (not fixed) from one sheet to the first empty cell of col A of another
    By stephenckwok in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-30-2012, 01:30 PM
  5. [SOLVED] Locating Duplicate Cell Data with a Cell Counter and Highlight
    By garrett.grillo in forum Excel General
    Replies: 1
    Last Post: 04-30-2012, 12:52 AM
  6. if cell in column B has data autofill cell in column A with a fixed text
    By wolfen in forum Excel General
    Replies: 6
    Last Post: 02-23-2012, 11:18 PM
  7. Combine data from one cell to another based on duplicate data in another cell
    By bzenker in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-15-2011, 01:09 AM
  8. Macro-Copy&Paste Fixed Data Ranges Into Last Empty Cell of Specific Column
    By hailnorm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2009, 10:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1