Hi Jay

Work on a copy of your Data - just in case!!!

Create your set of headings in Row 1 as you wish.
In cell D2 enter
=IF(A2=A4,C3,"")
In cell E2 enter
=IF(A2=A4,C4,"")
Copy D2:E2 down column D as far as your data extends.
Mark your Headers, then DataAutofilterUse dropdown on Column DSelect
Blanks
Delete visible rows

--
Regards

Roger Govier


"Jay Weiss" wrote in message
oups.com...
Hi,

Here's a new one... A database query produced a report in the form of
name-value pairs, like this:

PLANT_LOCATION, VARIABLE, VALUE
New York, NumEmployees, 2454
New York, PlantSize, 125000
New York, PlantAge, 27
Toronto, NumEmployees, 2733
Toronto, PlantSize, 94000
Toronto, PlantAge, 15
...

Note that the same set of name-value pairs always appear in the same
order for each plant.

To work with these data, I need to put them in a more typical Excel
flat-file format with variables in columns and records in rows, e.g.:

PLANT_LOCATION, NumEmployees, PlantSize, Age
New York, 2454, 125000, 27
Toronto, 2733, 94000, 15
...

How do I do it? Any ideas? Please? I'm using Excel 2003.

Thanks to anyone who can help!

...Jay