+ Reply to Thread
Results 1 to 4 of 4

Multiple name duplication

  1. #1
    Registered User
    Join Date
    01-11-2019
    Location
    Beer-Sheva, Israel
    MS-Off Ver
    2016
    Posts
    3

    Multiple name duplication

    I have a list of names (Colom A) that I want to duplicate (Colom B) , each name need to repeat 3 times before moving on to the next name on the list

    Colom A Colom B

    Name A Name A
    Name B Name A
    Name C Name A
    Name B
    Name B
    Name B
    Name B
    Name C
    Name C
    Name C

    Thanks in advance for your help!
    Last edited by ysaroya; 01-14-2019 at 07:46 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    354

    Re: Multiple name duplication

    If your names are in A1:A3 then

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

  3. #3
    Registered User
    Join Date
    01-11-2019
    Location
    Beer-Sheva, Israel
    MS-Off Ver
    2016
    Posts
    3

    Re: Multiple name duplication

    Quote Originally Posted by ysaroya View Post
    I have a list of names (Colom A) that I want to duplicate (Colom B) , each name need to repeat 3 times before moving on to the next name on the list

    Colom A Colom B

    Name A Name A
    Name B Name A
    Name C Name A
    Name B
    Name B
    Name B
    Name B
    Name C
    Name C
    Name C

    Thanks in advance for your help!
    It did alittle mess after posting....Colom A - Name A, Name B, Name C
    Colom B - Name A, Name A, Name A, Name B, Name B, Name B, Name C, Name C, Name C.

  4. #4
    Registered User
    Join Date
    01-11-2019
    Location
    Beer-Sheva, Israel
    MS-Off Ver
    2016
    Posts
    3

    Re: Multiple name duplication

    Thanks A LOT!!!!
    you guys are awesome!

+ 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