LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
DS
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Tables - Variance and % Variance fields CraigS Excel Discussion (Misc queries) 5 January 6th 05 12:22 AM
How to paste Xcel tables legibly into Word . Help!! Nimo Excel Discussion (Misc queries) 1 December 14th 04 09:53 PM
How do I fix column widths in Excel Pivot Tables? skeezix Excel Discussion (Misc queries) 1 December 11th 04 12:43 AM
Pivot Tables Karen Excel Discussion (Misc queries) 1 November 30th 04 03:56 PM
merging multiple pivot tables L Aichler Excel Worksheet Functions 0 November 18th 04 10:31 PM


All times are GMT +1. The time now is 04:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"