M
Mark Roach
Is there an Excel formula or VB procedure to take the raw data below and
produce the output, also shown below?
raw data:
WELL ZONE COUNTY STATE DEPTH POROSITY
1 A HARRIS TX 3000 0.14
1 C HARRIS TX 3500 0.33
1 D HARRIS TX 4500 0.21
2 B PECOS TX 3300 0.11
2 D PECOS TX 4700 0.34
3 A GREENE MO 4000 0.22
3 E GREENE MO 5000 0.19
3 F GREENE MO 6000 0.17
output:
WELL 1 2 3
COUNTY HARRIS PECOS GREENE
STATE TX TX MO
ZONE A
DEPTH 3000 4000
POROSITY 0.14 0.22
ZONE B
DEPTH 3300
POROSITY 0.11
ZONE C
DEPTH 3500
POROSITY 0.33
ZONE D
DEPTH 4500 4700
POROSITY 0.21 0.34
ZONE E
DEPTH 5000
POROSITY 0.19
ZONE F
DEPTH 6000
POROSITY 0.17
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!
produce the output, also shown below?
raw data:
WELL ZONE COUNTY STATE DEPTH POROSITY
1 A HARRIS TX 3000 0.14
1 C HARRIS TX 3500 0.33
1 D HARRIS TX 4500 0.21
2 B PECOS TX 3300 0.11
2 D PECOS TX 4700 0.34
3 A GREENE MO 4000 0.22
3 E GREENE MO 5000 0.19
3 F GREENE MO 6000 0.17
output:
WELL 1 2 3
COUNTY HARRIS PECOS GREENE
STATE TX TX MO
ZONE A
DEPTH 3000 4000
POROSITY 0.14 0.22
ZONE B
DEPTH 3300
POROSITY 0.11
ZONE C
DEPTH 3500
POROSITY 0.33
ZONE D
DEPTH 4500 4700
POROSITY 0.21 0.34
ZONE E
DEPTH 5000
POROSITY 0.19
ZONE F
DEPTH 6000
POROSITY 0.17
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!