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