Many thanks Daniel > The spreadsheets we are going to be querying are to be updated automatically so there won't be any human interaction to use transpose.
I'd love you to help with a javascript solution, I'm OK with javascript so if you could give me some help that would be great. I would also like to label each of the values if that's possible? Alternatively - I wonder - is there a way of finding out what row the UPN ' 77abc' appears in and then I could query a range? Thanks :) Rob -- You received this message because you are subscribed to the Google Groups "Google Chart API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-chart-api. For more options, visit https://groups.google.com/d/optout.
