Wednesday, September 19, 2012

yogi_Insert Value in Column B As ANew Line After Every Value In Corresponding Row In Column A Row By Row

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #764   Sep 19, 2012     www.energyefficientbuild.com


user jazzybeat said: (http://productforums.google.com/forum/?zx=y7jq6icx61c4#!category-topic/docs/spreadsheets/GFTOof7UNuA)
If cell is empty hide LineBrake CHAR(13)
Hello, 
I'm trying to get values from columns A,B,C into on sigle cell and seperate values with line brakes. My problem is that I can't understund how to insert IF statment, inside CONCATENATE with CHAR(13).

Bellow is the link of the document. Perhaps some one can help me with this.
Thanks

https://docs.google.com/spreadsheet/ccc?key=0AiUyMzdcMevLdDlWYjVOVl80b0E2dUI3QW1NcmdfcWc
----

I have one more question let say I want to insert after each non empty value aditional value with a line brake, how would I do this? you can see this on Sheet2.
Thanks

-------------------------------------------------------------------
following is a solution to a bit more generalized problem