I have a relatively simple data matrix

Property Zone Acreage
1000 R 1.00
1000 C 1.20
2000 R 1.40
2000 C 0.50
2000 S 1.30
3000 R 0.75
3000 S 2.00

That contains mutiple occurances of the same property. Each occurance
of the same property is a different zone. There is one unque record
(row) for each combination of Property and Zone.

I wish to create a new table with each row being the unique property
and each column having the acreage for each unique zone. Some
combinations will result ina null value. I already have the unique
properties in the left column and I have the unique zones as the column
headers.

Property R C S
1000 1.00 1.20 null
2000 1.40 0.50 1.30
3000 0.75 null 2.00


--
James Hobart
------------------------------------------------------------------------
James Hobart's Profile: http://www.excelforum.com/member.php...o&userid=17540
View this thread: http://www.excelforum.com/showthread...hreadid=480186