making a time series
 

Could someone let me know the code to do this? If you have a very long
list like this:

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

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

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

And also check for cases where there are more than one person`s name for
the same company and quarter.

Theoretically, a pivot table would be able to do this. But, I don't
think string names can be put in the data section of a pivot table. Is
there any way around this? Or would VB be the only way?

Matthew Kramer




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