Breakdown grouping

[red_jellybean]

I need to breakdown the spreadsheet.
Origin City, Origin State, Dest City, Dest ST, Product Code = Freight Rate.

Somehow, the data provided to me is
Origin Group, Dest Group, Product code group = Freight Rate

and then a seperate spreadsheet with the cities in the Origin Group or
cities in the Dest Group and also Product Codes in the grouping.

I would like to know if there is a way to split the grouping up and make it
show specific Origin, Dest, Product Code.

Origin Dest Product Code
Rate
Houston Group Midland Group 28181 $1000

Houston Group
Houston
Deer Park
Dallas

Midland Group
Midland
Bay City
Saginaw

28181 Group
2818101
2818102
2818103

So any combination of the 3 groups will have the same frieght rate of $1000

 

[Charlie]

I can't help but notice the data. Look's like you could be down the hall
from me. Dial x2158, if I answer the phone I can help you with your
workbook. If someone else answers don't tell 'em who sent you!

 

[red_jellybean]

How do you know if I'm down the hall from you? I don't recall populating any
personal data. Where r u located?

 

[Charlie]

No, not personal data. We have offices in some of these places (I'm in
Houston) and I thought you might be up in the purchasing group (judging by
Freight Rate). But, it was just a wild guess.

Your workbook problem would be easier to solve by someone who could look at
the whole package, and I was willing to do that if we were in the same
office, but it's a little more complex than I usually try to answer here.
Someone may try. You may need to provide more details though.

Regards,
Charlie