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

user jazzybeat said: (!category-topic/docs/spreadsheets/GFTOof7UNuA)
If cell is empty hide LineBrake CHAR(13)
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.

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.

following is a solution to a bit more generalized problem