This is going to be painful to explain- apologies in advance!
I have an exported Excel Spreadsheet that contains a record set in which each row is uniquely identified by the "Agent Name" Column and the "Ticket #" Column. Only one unique Ticket number can be assigned per sale, per Agent.
Unfortunately for me, the data base that this file is exported from is butchering the export because the last field ("Remarks") is a free-form text field, and the text is messed up with hidden line breaks, and other hidden characters in the data base itself...the result is the export of each record is getting duplicate rows of the same sale, with the "Remarks" field being split out in multiple rows.
(I don't have admin rights on the data-base, so can't fix the problem on that side)
I hope the following illustrates what I'm trying to do...
This is an example of what is exported, Note column E text:
This is what it SHOULD be:
any help would be appreciated!
blbat
Excel 2016
I have an exported Excel Spreadsheet that contains a record set in which each row is uniquely identified by the "Agent Name" Column and the "Ticket #" Column. Only one unique Ticket number can be assigned per sale, per Agent.
Unfortunately for me, the data base that this file is exported from is butchering the export because the last field ("Remarks") is a free-form text field, and the text is messed up with hidden line breaks, and other hidden characters in the data base itself...the result is the export of each record is getting duplicate rows of the same sale, with the "Remarks" field being split out in multiple rows.
(I don't have admin rights on the data-base, so can't fix the problem on that side)
I hope the following illustrates what I'm trying to do...
This is an example of what is exported, Note column E text:
This is what it SHOULD be:
any help would be appreciated!
blbat
Excel 2016