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