Rob,
You may not need this anymore, but in case anyone else is interested, I
learned from one of the Spreadsheet developers how you can do a transpose
of a row of data that you search for by a string.
Basically, do the search with MATCH, and specify the range of cells to be
transposed with OFFSET.
1. Search for "Row D" in rows K1:K6, use =MATCH("Row D",K1:K6)
- Instead of "Row D", you can use the value in another cell, say A1: =
MATCH(A1,K1:K6)
- To search all rows in column K, use K1:K.
2. To get the columns K through O in that row, use =OFFSET(K1:O1, match -
1, 0), where match is the result of the MATCH expression.
- To get all columns after K, use K1:1.
- You can put this offset result in another cell, and the offset
values will fill columns starting from there.
3. Transpose the offset row with TRANSPOSE(offset).
So all in one expression, it looks like this:
=TRANSPOSE(OFFSET(K1:O1,MATCH("Row
D",K1:K6) - 1, 0))
On Mon, Oct 27, 2014 at 8:49 AM, Rob H <[email protected]> wrote:
> Hi Daniel, I've been busy over here. I'be got a solution that's working
> (based on your javascript implementation). My only concern is looping
> through such a big object but time will tell if that has any performance
> issues.
>
> Thanks again for your help - I know a lot more now than I did! :)
>
> Cheers
> 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.
>
--
Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> -
978-394-1058
[email protected] <[email protected]> 5CC, Cambridge MA
[email protected] <[email protected]> 9 Juniper Ridge
Road, Acton MA
--
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.
