With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Saturday, August 4, 2012
yogi_Rearrange Data By Entities In Column B C D And Set Of Specified Number of Columns _Solution2
I'm trying to organize the spreadsheet to a new way. I'm wondering is the query function able to do this and I have tried to think it with many ways but I do need some help. Perhaps I'm thinking too difficult :-)
I have a form that collect the information from one team to one row. I need better way to show them and I will make individual sheets for every age group to publish. I made an example sheet what I need to do.
Thanks for the example. I tried it and it works. Then I realized a huge problem: I will have 800 teams in one season and 80 colums in the main page (form) so it means 64.000 cells and because I have 6 individual sheets for every age group, it will double 128.000. This is still under the limit so everything is okey.. If I use Index formula as in your example, I will have approx. 800 teams * 15 players * 5 cell = 60.000 formulas and that's over the limit. Query or arrayformula would fix this problem because the continue is not caltulated as a formula (as I red from another post). Now the problem is how to use this formula in my case?