The transpose formula should do this, if you use it with the appropriate parameters. You can leave off the letter or number in a part of the range to indicate all rows or columns. So in your case, to get rows 1 and 2 of all columns after column D, try =TRANSPOSE(D1:2)
On Wed, Oct 22, 2014 at 12:08 PM, Rob H <[email protected]> wrote: > Thanks again Daniel - re the Transpose method, is there way to automate > Transpose for all rows (including any added) into a new sheet? > > -- > 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.
