# Need Formula to Join to Columns and Duplicate

1. ## 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

Maybe:
=A12&C12

3. ## 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

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

#### 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