I have a report on Excel 2007 and it is a list of owners and their property, mailing address and legal description of their parcels of land. I am trying to help out marketing with the mailing. Since several owners own more then one property, marketing would like to have report with the owner listed once and each parcel listed in that one cell by legal description. If I eliminate duplicates, it removed all of the data. Is there some way I can merge the duplicates data? This is new to me and I have tried Excel and Access and do not see how I would accomplish this.
On Jun 24, 8:31 pm, Ellen wrote: > I have a report on Excel 2007 and it is a list of owners and their property, > mailing address and legal description of their parcels of land. I am trying > to help out marketing with the mailing. Since several owners own more then > one property, marketing would like to have report with the owner listed once > and each parcel listed in that one cell by legal description. If I eliminate > duplicates, it removed all of the data. Is there some way I can merge the > duplicates data? This is new to me and I have tried Excel and Access and do > not see how I would accomplish this. This newsgroup focuses on Microsoft Content Management Server related questions. Please post your question into either a Excel/Access or other related newsgroup.
