2 Replies Latest reply on Feb 26, 2015 11:07 AM by angusm57634069

    Script to remove row if a cell is blank

    angusm57634069

      Hello,

       

      Im trying to find a script that will remove a row (shifting subsequent rows up) if one of the cells in the row (there are 2 columns) is blank.

       

      Im creating table based docs using datamerge and there are rows with dataheadings (in column 2) and the datavalues (in column 1) for the rows are imported via the merge. Not every heading has a value so I want a script to remove the rows where no value is present.

       

      I have found scripts that work however due to the end text # markers that are left after the merge I think they see the cell as being populated.

       

      Thanks for you help