Mark -

Doesn't sound like you gave it much of a try. Select your data, and generate a pivot
table (Data menu).

Drag the Well, County, and State fields to the columns area. If they aren't in the
order you want, drag the buttons around within the columns area to see how that
changes the order.

Drag the Zone field to the Rows area.

Drag the Depth and Porosity fields to the Data area. If they aren't in the right
order, drag them around.

The nice thing about a pivot table is that you can very easily move the different
field buttons, within an area or to another area. To get rid of subtotals, double
click on the buttons, and choose the None option for Subtotals.

Here's a 30-second pivot table of your data:

WELL COUNTY STATE
1 2 3
HARRIS PECOS GREENE
ZONE Data TX TX MO
A DEPTH 3000 4000
POROS 0.14 0.22
B DEPTH 3300
POROS 0.11
C DEPTH 3500
POROS 0.33
D DEPTH 4500 4700
POROS 0.21 0.34
E DEPTH 5000
POROS 0.19
F DEPTH 6000
POROS 0.17


- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Mark Roach wrote:

Is there a way to move text around with a pivot table? e.g., if the
data element is County or State, in addition to something like depth or
porosity?

Mark Roach
Vice President Technical Resources
The Oil & Gas Asset Clearinghouse
Houston, Texas

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!