M
Matthew Kramer
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!
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!