PDA

View Full Version : Preparation of excel spreadsheet data for google motion charts api (VBA?)



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! :)

GTO
06-02-2009, 10:02 PM
Greetings John,

Firstly, I see this is your first post and want to say "Howdy" and offer a friendly welcome. You will get to 'meet' some great folks here, who will go out of their way to assist :-)

Now as to your question... it might just be me, but this seemed awfully unclear. I think you have to have five posts before you can attach a wb, but in the meantime could you specify where the "things" and years are and give some sample data or maybe a screenshot?

Hope this helps,

Mark