+ Reply to Thread
Results 1 to 2 of 2

how to produce doubles of each row in excel

  1. #1
    Registered User
    Join Date
    11-18-2020
    Location
    Reno, NV
    MS-Off Ver
    2016
    Posts
    1

    how to produce doubles of each row in excel

    So I have an excel workbook and i need each row to have an exact duplicate. Example given below

    ID state code
    100 32 1001
    101 32 1002

    This would become

    ID state code
    100 32 1001
    100 32 1001
    101 32 1002
    101 32 1002

    Is this a VBA function or something formula based?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: how to produce doubles of each row in excel

    Please Login or Register  to view this content.
    How to install your new code
    • Copy the Excel VBA code
    • Select the workbook in which you want to store the Excel VBA code
    • Press Alt+F11 to open the Visual Basic Editor
    • Choose Insert > Module
    • Edit > Paste the macro into the module that appeared
    • Close the VBEditor
    • Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)


    To run the Excel VBA code:
    • Press Alt-F8 to open the macro list
    • Select a macro in the list
    • Click the Run button
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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] take out ALL doubles from a column
    By incobart in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2018, 09:01 AM
  2. count doubles
    By newx in forum Excel General
    Replies: 3
    Last Post: 06-17-2012, 06:00 PM
  3. [SOLVED] How can I avoid doubles?
    By lauro in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-29-2012, 06:11 PM
  4. Using Excel to produce a report
    By Sinking Ship in forum Excel General
    Replies: 5
    Last Post: 09-22-2011, 07:53 PM
  5. Removing Doubles
    By DORMAX34 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-01-2007, 04:08 PM
  6. produce a formulate to produce assigned seats for dinner
    By DavidJoss in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-03-2005, 10:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1