ignore BLANK LINES (cells) mail merge

[McCoy Dodsworth]

Hello,

I'm using autocrat to produce a paper program for an awards event. I need to print each student's name and the award they are receiving - each student is receiving one to four awards but never all of them. I need the merge to IGNORE blank lines (cells) in spreadsheet. Right now it inserts a line break. Please help!

Here is what my template looks like:

<<First>> <<Last>>

   <<SIH 1>>

<<SIH 2>>

<<Academic Excellence Certificate>>

<<AEC 2>>

<<Community Service Certificate>>

<<Community Youth Service Award>>

<<Federation Life Member>>

<<State Seal of Biliteracy Spanish>>

<<State Seal of Biliteracy French>>

<<Scholarship>>

It give me this:

Higga  Aosta

   

Federation Life Member

I want:

Higga  Aosta

Federation Life Member

[Joseph Schmidt]

You can add a new column and put in it the desired outcome.  You can use an arrayformula or copy the formula.

The CHAR(10) will go to the next line.  

Your formula would be something like.  If(A2="yes","A desc"&Char(10),"")&if(b2="yes","b desc"&char(10,"")&  etc.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

Notice to Recipient:

Information contained in this message may be privileged, confidential and protected from disclosure. If you are not an intended recipient, it is strictly prohibited to use, disseminate or copy this communication. If you have received this in error, please reply to the sender and then delete the message.

Thank you.

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/447fd1d8-d84a-4e13-afc5-5889e1f70fc4n%40googlegroups.com.

[Hervé AGUILANIEDO]

hi,

I wish do the same action,

the sheet is big and some lines have adresse or adresse2 or adresse4 not empty

i copied, pasted the formula but it return an error:

So i have 2 questions to understand the formula

1/ Why is the value "yes" ?

2/ what's the meaning of "desc"

Screen capture, thanks for help

Hervé A