Is there a range function in Google Spreadsheets where I can link the values of SheetA!A1:A10 to SheetB!A1:J1? So basically rotating the values from rows to columns.
I have a spreadsheet in Google Docs with two data rows and lots of columns like so:    Is it possible to easily convert these rows into two columns and lots of rows (obviously retaining all information and formulas)? In other words, to something like this:   19.9.2009   967,15 €  28.9.2009   950,78 € 12.11.2009   942,03 € ..           ..   There's probably a neat mathematical term for such a conversion, but I don't remember which (matrix something?). Feel free to suggest a better name for the question.  Edit: To clarify, ultimately I want to get rid of the original (two row) version and continue working on the converted one. TRANSPOSE(), , got me very close but not quite there. I want the raw data in the transposed version, not cells that mirror the original ones.
Opening a context menu (with the Menu key) Convert one date format into another in PHP When and why is the [featured] tag removed by the Community user? It's been sometime and Google has yet to index my site. How can I get Google to index my website? Let $R$ be a ring (unital, not necessarily commutative), $M$ a finitely presented left $R$ module. Suppose $m_1,\ldots,m_n\in M$ generate $M$. This determines a surjection $f:R^n\to M$.     Must the kernel of $f$ be finitely generated?   This is true by definition if the generating set $m_1,\ldots,m_n$ is the one coming from the finite presentation of $M$. Where are static variables stored in C and C++? What's the difference between Fermi Energy and Fermi Level? I'm a bit confused about the difference between these two concepts. According to Wikipedia the  and  are closely related concepts. From my understanding, the Fermi energy is the highest occupied energy level of a system in absolute zero? Is that correct? Then what's the difference between Fermi energy and Fermi level? Meaning of 'no earlier than X days after Y' I am having trouble understanding the following notice on the American Airlines AAdvantage (miles account) :     Note: Mileage credit requests can be submitted no earlier than 15 days   after all travel is completed.   What does it exactly mean? Which of the following statements is the correct interpretation?   I have to wait for 15 days after all my travel is completed before I can request my mileage credit If I want to request my mileage credit, I have to do so within 15 days after my travel is completed Something else   In any case, I wonder, is the original statement grammatically correct? I'm struggling to understand the core reason to invest in stocks as a minority shareholder. Majority shareholding makes more sense as you effectively control the company, so you can pay yourself dividends or even sell the entire company at will. You can guarantee your own payback.  However, as a minority shareholder, you don't get to make any of these decisions. You're basically just hoping to eventually, some day get paid, if the majority holders decide so.  Why do so many investors agree to pay now huge sums of money (trillions in total) for something that may eventually pay dividends, and even in the best case, these dividends are only a fraction of the price you paid to acquire these stocks?  The average annual dividend rate for the US stock market is 2%. That means if you bought 100 million worth of shares, you'd have to wait 50 years to recover your investment.  Of course, the most probable way you'd eventually get liquidity for these shares is by selling them to some other starry-eyed investor - which makes the whole thing seem like a giant Ponzi scheme.  Given all that, it's unclear to me why the public is willing to spend so much money to acquire minority shares in companies. Your answer is in another castle: when is an answer not an answer? How to provide a file download from a JSF backing bean? How does the Higgs mechanism work? I'm not a particle physicist, but I did manage to get through the Feynman lectures without getting too lost. Is there a way to explain how the Higgs field works, in a way that people like me might have a hope of understanding? How to show that $\mathfrak{sl}_n(\mathbb{R})$ and $\mathfrak{sl}_n(\mathbb{C})$ are simple? Essentially, I would like to set my phone so that all my outgoing messages to a specific friend, with whom I currently text back and forth over iMessage, are sent out over SMS, never iMessage. Additionally, I would like to block any incoming iMessage texts of his and (hopefully) they'll fail and be resent via SMS.  Let me restate that: I would like to force SMS for both parties, going both ways, for a specific individual contact.   Is this possible? Blocking any usage of iMessage between myself and this other individual, so they must either send and receive any texts to or from me via SMS (or the texts fail/never arrive). How to Regex search/replace only first occurrence in a string in .NET? It seems the .NET Regex.Replace method automatically replaces all matching occurrences.  I could provide a MatchEvaluator delegate that returns the matched string after the first replacement, rendering no change, but that sounds very inefficient to me.  What is the most efficient way to stop after the first replacement? VirtualBox - how to increase video memory? Note: The legacy Skype for Linux application (v4.*) is now discontinued and was removed from Canonical’s partner repositories, so this question and its answers are obsolete. Please refer to  of our .  Skype 4.3 is just released with considerable improvements. As a regular Skype user I want to use the latest Skype on my Ubuntu 14.04, but there is no updates from Update Manager. Even in Skype website only Skype 4.3 is available only for Ubuntu 12.04. Is there anyway to use this latest Skype on Ubuntu 14.04 or how much we have to wait for the update? How can I find $\gcd(a^m+1,a^n+1)$ with $a,m,n$ positive integers?    I have this idea:  Let $d=\gcd(m,n)$. Then there exist positive integers $x,y$ such that $mx-ny=d$ (WLOG). We shall find $G=\gcd(a^m+1,a^n+1)$.  If $m,n$ are odd, then $d$ is odd, therefore one and only one of $x,y$ is even. We have:  $$a^{ny}(a^d+1)=a^{mx}+a^{ny}=(a^{mx}-1)+(a^{ny}+1)=(a^{mx}+1)+(a^{ny}-1).$$  If $x$ is even and $y$ is odd, then $a^{m}+1\mid a^{mx}-1$ and $a^{n}+1\mid a^{ny}+1$, therefore $G\mid a^{ny}(a^d+1)$. If $x$ is odd and $y$ is even, then $a^{m}+1\mid a^{mx}+1$ and $a^{n}+1\mid a^{ny}-1$, thus $G\mid a^{ny}(a^d+1)$. However, since $\gcd(a^m+1,a^{ny})=\gcd(a^n+1,a^{ny})=1$, so $\gcd(G,a^{ny})=1$, hence $G\mid a^d+1$. We also have $a^d+1\mid a^{m}+1$ and $a^d+1\mid a^{n}+1$, so $a^d+1\mid G$. Thus $G=a^d+1$.  If $v_2(m)=v_2(n)=v_2(d)=k&gt;1$, then there exist some odd numbers $m_1,n_1,d_1$ such that $m=2^km_1,n=2^kn_1,d=2^kd_1$. We shall have $m_1x-n_1y=d_1$, so one and only one of $x,y$ is even, and we can use the same argument when $m,n$ are odd, so $G=a^d+1$.  However, if $v_2(m) \neq v_2(n)$, I cannot find any solutions for this. I think that $G \in \{1,2\}$, but I cannot prove or disprove it. How can I find $G=\gcd(a^m+1,a^n+1)$ if $v_2(m) \neq v_2(n)$ ? Moreover, is there anything from my arguments that can be improved ? Why do some games allow offline Steam achievements? I know of  where it is asked if you can get Steam achievements offline. The accepted answer to that was no.   But I do earn achievements for some Steam games while playing in offline mode!  For example, right now I am earning achievements for Cave Story+ as I play in offline mode. In other games I also earn achievements while playing in offline mode. Not just when I am disconnected but still in "online" mode as might be suggested in the linked question.  But what is really bugging me is that this does not happen with all games that have Steam achievements.  So, is allowing offline achievements something that Steam allows, the game devs allow, or is it something decided by a magical elf in the steam servers rolling some d20 dice around?  Edit:  As per request, I was able to attain visual evidence:    You should be able to see the achievement-get in action while in offline mode.  What is worth noting, (and something that I forgot to mention before) is that I only started earning achievements after I had went into online mode with the game installed. This is why I was able to earn this achievement with the ones after unlocked. I had started the game for the first time in offline mode, and did not notice that I was not earning achievements. When I had connected once, I did not have to start the game while online. I was able to earn achievements offline.  I also must state publicly: I do not play on easy. This was for testing purposes only people. It was for Science! Retrieve Preview Image URL of Salesforce Image Files