+ Reply to Thread
Results 1 to 3 of 3

Need Formula to Join to Columns and Duplicate

  1. #1
    Registered User
    Join Date
    03-09-2011
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2016
    Posts
    21

    Need Formula to Join to Columns and Duplicate

    Can someone help me with a formula? Thanks.

    Part Code
    A 05002
    B 05037
    C 05239
    D 05475


    A FORMULA TO TURN INTO THIS



    A 05002 A05002
    B 05002 B05002
    C 05002 C05002
    D 05002 D05002
    A 05037 A05037
    B 05037 B05037
    C 05037 C05037
    D 05037 D05037
    A 05239 A05239
    B 05239 B05239
    C 05239 C05239
    D 05239 D05239
    A 05475 A05475
    B 05475 B05475
    C 05475 C05475
    D 05475 D05475
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-15-2015
    Location
    Cecoslovacchia
    MS-Off Ver
    365 personal
    Posts
    100

    Re: Need Formula to Join to Columns and Duplicate

    Maybe:
    =A12&C12

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: Need Formula to Join to Columns and Duplicate

    Put this formula in A12:

    =INDEX(A$2:A$5,MOD(ROWS($1:1)-1,4)+1)

    and this in C12:

    =INDEX(C$2:C$5,INT((ROWS($1:1)-1)/4)+1)

    and copy both down to row 27. If you want to generate column D directly, you can use this formula:

    =INDEX(A$2:A$5,MOD(ROWS($1:1)-1,4)+1)&INDEX(C$2:C$5,INT((ROWS($1:1)-1)/4)+1)

    then copy down 16 rows.

    Hope this helps.

    Pete

+ 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. SQL - Join two columns into one
    By kenny.fsw in forum Access Tables & Databases
    Replies: 4
    Last Post: 08-02-2012, 04:03 AM
  2. Join columns
    By MFT in forum Excel General
    Replies: 4
    Last Post: 04-27-2010, 10:02 AM
  3. join tables with duplicate records ??
    By okl in forum Access Tables & Databases
    Replies: 1
    Last Post: 11-16-2009, 03:40 PM
  4. join two columns....
    By visitnag in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-17-2008, 01:25 PM
  5. Is it possible to join columns where there is a match?
    By QuickLearner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2006, 06:10 PM

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