I am working with data that has more than one line of data in spots but not the whole data. I need to trap this data without then repeating the data in cells without that data. Below is a sample. I have tried append, page header and page footer. They all repeated the data when it isn't included in the line once it gets back…