combining columns
 

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

combining columns
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jason2444" wrote in message
...
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

combining columns
 

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


"jason2444" wrote:

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

combining columns
 

"Shane Devenshire" wrote:

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


"jason2444" wrote:

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

combining columns
 

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.