Hello,
We print compensation statements for some of our clients and we have a client who has hundreds of different line items that are applicable to certain employees, but the data is supplied in one Excel file for its 1,500 employees. The client is demanding that any field that does not apply to a specific employee should be deleted (as in that row in the table be removed rather than just be left blank).
Is there a way to set up data merge formatting in InDesign to delete a cell if a value is not added to an existing field?
Thanks!