I have an Excel data sheet from a client that needs to be turned into a multiple page print doc.
Each attendee at an event gets a page each with details listed. I can achieve this with a basic data merge.
However, each client has selected certain things they are interested in and the client has created a matrix as shown where 1 means they are interested in the subject in the column header and 0 means they are not.
Is there an way, a script or extension or something, that will let me data merge these 1s and 0s into a simple list of the subjects they have chosen.
Any help greatly appreciated
You need to add a column or columns tot eh spreadsheet and use some sort of logical formula to populate based on the zeros and ones, then merge that column.
Thanks Peter, that makes sense.
Off to the excel forum I go then...