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.
Monday, February 18, 2013
yogi_Transpose And Join Data In One Column Of Sheet1 Based On Specified Conditions In Sheet1
Google Spreadsheet Post #1034
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Feb 18, 2013 user Michael Smit said:(http://productforums.google.com/forum/?zx=4jqkdv8lkjz7#!category-topic/docs/spreadsheets/jrIOJTP7eGk) How to transpose data from one column, only if certain conditions are met by each row in that column
Hi - I have a very large spreadsheet of various items and related info (will be over 1000 rows, and frequently being added to or updated). I need to transpose the item names in column A to distinct datasets. For ex:
For whatever reason, I can't get the data to sort, on the 3rd and 4th sheets (it should be 8,11,10 if sorting the output descending on column H, but it still shows as 8,10,11). Maybe my column H reference has poor syntax?