I used the pivot table and it worked like a charm.
However, the data is going to be transferred into another program
and it needs to be in the same format as the original with headers like:

State County Tons Commodity

I have played around with the pivot table some, but it is not right.
Perhaps a formula or function would work better? Thanks!


--
taz0923