Forgot to mention in the message I just sent - is there a more
straightforward way to do this rather than using a pivot table. If you
have a very long list like this:

company quarter name
McDonalds 1 John
McDonalds 2 Joe
Pepsi 1 Adam
etc.

Is there a way to loop through row and put the data in the final form:

company quarter 1 quarter 2 quarter 3 quarter 4
McDonalds John Joe Sandra Peter
Pepsi Adam John Mary Chris
etc.

while also checking in case there are more than one person`s name for
the same company and quarter.

Matthew

message sent a few minutes ago:

Is it possible to create a pivot table putting names or string text in
the area where the data usually is or would VB needed for that?

For example

company quarter 1 quarter 2 quarter 3 quarter 4
McDonalds John Joe Sandra Peter
Pepsi Adam John Mary Chris


from this data:

company quarter name
McDonalds 1 John
McDonalds 2 Joe
Pepsi 1 Adam
etc.

Matthew




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