2 Replies Latest reply on Sep 16, 2015 4:54 PM by shandmedia

    InDesign data merge true or false to create list

    shandmedia Level 1

      Hi,

       

      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

      My next option is to try and do something with the Excel file but I'm far from expert in Office.Excelgrab.jpg