Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Series and Creating data points within a series | Excel Discussion (Misc queries) | |||
Making a drop down control to choose a data series | Charts and Charting in Excel | |||
Making a trend line for several series of data | Excel Worksheet Functions | |||
Data Series Name issue making a Chart from a PivotTable | Charts and Charting in Excel | |||
making a time a measurement of time, not an hour of the day?? | Excel Discussion (Misc queries) |