I'm sorry but I don't understand the exact structure(s). Can you provide an example part of the spreadsheet and the example result you expect?
- VizBoy. On Tue, Jun 2, 2009 at 7:49 AM, John Musbach <[email protected]> wrote: > > Hi, I have a series of excel spreadsheets whose data is in a format > like so > > Things years .... > Thing 1 <numbers under each year> > Thing 2 > Thing 3 > .... > > where the ultimate goal, obviously, is to translate the spreadsheet > layout such that it becomes > > Things > Thing 1 <year 1> number > Thing 2 <year 1> number > Thing 3 <year 1> number > ... > Thing 1 <year 2> number > Thing 2 <year 2> number > ... > > But I'm not sure how to do this translation, particularly automating > the repetition of things for proper realigning of the years and their > associated numbers. Does anyone have any ideas? Thanks! > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en -~----------~----~----~----~------~----~------~--~---
