Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
How to paste Xcel tables legibly into Word . Help!! | Excel Discussion (Misc queries) | |||
How do I fix column widths in Excel Pivot Tables? | Excel Discussion (Misc queries) | |||
Pivot Tables | Excel Discussion (Misc queries) | |||
merging multiple pivot tables | Excel Worksheet Functions |