autoexpanding two tables
I've got a list of 58 customer records in one worksheet, I've got 1090
records of pricing data. In both cases, the data is unique. I need to end
up with rows of data that consist of each customer (table 1) having 1090
records of pricing data, then advance to next customer number...etc.
Table 1
cust1
cust2
cust3
etc
Table 2
PG5 Price$
PG6 Price$
PG7 Price$
Result
cust1 PG5 Price$
cust1 PG6 Price$
cust1 PG7 Price$
cust2 PG5 Price$
cust2 PG6 Price$
cust2 PG7 Price$
cust3 PG5 Price$
cust3 PG6 Price$
cust3 PG7 Price$
result will be 58x1090 - 63,220 rows of data
Appreciate any help-
Dane
|