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 -~----------~----~----~----~------~----~------~--~---
