pivot table question

M

Matthew Kramer

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table question 0
making a time series 0
calculations in large data set and in pivot table 0
Calculations in a pivot table data set 2
Re-driecting a pivot quarterly 1
pivot managment through VBA 2
How do I force a pivot column if there is no data? 5
Using a Defined Name Value in a Pivot Table 0

Top