John Musbach
06-02-2009, 07:15 AM
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!
P.S. I just wanted to clarify that to further complicate things, this
implementation must be able to handle a dynamic number of things and
years since the number varies between excel spreadsheets. Also, in
case it makes any difference, this is for preparation for automatic
addition of google motion charts to the excel spreadsheets
specifically and is not meant to be used in preparation for generic
utilization of the google visualization gadgets. Thanks! :)
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!
P.S. I just wanted to clarify that to further complicate things, this
implementation must be able to handle a dynamic number of things and
years since the number varies between excel spreadsheets. Also, in
case it makes any difference, this is for preparation for automatic
addition of google motion charts to the excel spreadsheets
specifically and is not meant to be used in preparation for generic
utilization of the google visualization gadgets. Thanks! :)