+ Reply to Thread
Results 1 to 2 of 2

Duplicating values in the same column

  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    AUS
    MS-Off Ver
    Excel 2007
    Posts
    2

    Duplicating values in the same column

    hi,

    i am trying to turn a set of numbers from a column:

    1
    2
    3
    4
    5


    Into this:

    1
    1
    1
    1
    1
    2
    2
    2
    2
    2
    3
    3
    3
    3
    3
    etc.

    i have 60 values in the column where i need to repeat each value 11 times,

    i have tried to look for guides but i am unsure what this is generally called!

    i think a macro could work? but i have no idea how to code them.

    any suggestions/help would be greatly appreciated!

  2. #2
    Registered User
    Join Date
    09-20-2012
    Location
    AUS
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Duplicating values in the same column

    i realised i can copy the column multiple times, then transpose the data from multiple rows into a column using a macro:

    Please Login or Register  to view this content.
    (incase other people need this! )

    note: i found the macro from another website, but im not sure if im allowed to link

    Credit goes to Derk from ozgrid/com
    Last edited by Cutter; 09-20-2012 at 07:31 PM. Reason: Added code tags

+ 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