combining columns

[jason2444]

line 1- 3000 has part number in column A and application information in
column B and price in column C. In column a1-a3000 i have multiple part
numbers EXAMPLE: AC7001
in column D1-D30 i have a product code. EXAMPLE: column D1 is 1A0 and D2 is
1A4 going all the way down to D30.

What i am trying to do is create 30 lines with the all the data in line 1
with the different appended product codes from D1 -D3

Example
AC7001-1A0 application info price info
AC7001-1A4 application info price info

so every part number in column A has to be paired with every product code
from column D so there will actually be 30 lines with AC7001 each line having
the different product code attached. need to keep all data from line 1
columns A,B,C together just adding the product code to end of part number in
A1.

any help would be appreciated

 

[Don Guillett]

Show us your before and after layout. Or, send your wb to my address below
along with clear explanations and examples.

 

[Shane Devenshire]

Hi,

Here is a formula approach:

Assume your data starts on row 1 and it assumes you have 30 items in column D.

In F1 enter
=OFFSET(A$1,(ROW()-1)/30,0)&" - "&OFFSET(D$1,MOD(ROW(D1)-1,30),)
In G1 enter
=OFFSET(B$1,(ROW()-1)/30,0)
in H1 enter
=OFFSET(C$1,(ROW()-1)/30,0)

Copy all these formulas down as far as necessary 30*3000 rows

Select all the formulas and copy, then edit, paste special, values

 

[jason2444]

Hi,

Here is a formula approach:

Assume your data starts on row 1 and it assumes you have 30 items in column D.

In F1 enter
=OFFSET(A$1,(ROW()-1)/30,0)&" - "&OFFSET(D$1,MOD(ROW(D1)-1,30),)
In G1 enter
=OFFSET(B$1,(ROW()-1)/30,0)
in H1 enter
=OFFSET(C$1,(ROW()-1)/30,0)

Copy all these formulas down as far as necessary 30*3000 rows

Select all the formulas and copy, then edit, paste special, values

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

I created a before and after example in excel with some sample parts as what
i am trying to accomplish is difficult to explain. with your vast knowledge
would you mind if i email you this before and after for you to look and and
edit your formula accordingly?

 

[jason2444]

Shane
i created a before and after sample of what i am trying to accomplish would
you mind if i email this to you to look at and adjust you formula
accordingly. As i am pretty new to this and it looks like you have vast
knowledge on the subject.