Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #581 Jun 07, 2012 www.energyefficientbuild.com.
the convoluted solution herein was pronmpted by a question like this in Google Docs Help forum
the convoluted solution herein was pronmpted by a question like this in Google Docs Help forum
Being an ardent fan of Google, I try my hands in all its services. But, I don't think Google docs really makes collaboration easy for me. It is same as an online excel. Google Docs does not allow me to hide multiple columns and rows in a file and share it with my friends.
ReplyDeleteFound this tool CollateBox that promises real collaboration. Currently giving out beta invitations.
Hi John:
ReplyDeleteGreat Info ... Thanks For Sharing.
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com
--Yogi,
ReplyDeleteBecause this formula is so far beyond my level of comfort, I'm having trouble getting this to work in a similar but slightly different situation. I'm trying to take data from a form and basically do what you've done with it, but in a new worksheet of the same workbook. Would you mind looking at the workbook I'm working from? I really really appreciate your help.
--Nancy
Hi Nancy:
ReplyDeleteI don't have access to your workbook ... so I have created the following blog post for you.
yogi_Rearrange In Sheet2 Unique Data In Columns Of A Table In Sheet1 By Entity In First Column Of The Table
http://yogi--anand-consulting.blogspot.com/2012/06/yogirearrange-in-sheet2-unique-data-in.html
I hope this helps.
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com