I need to import data from files provided by business. Since the files contain duplicates and i have to import all records so i am using numbered list for the import.
But moving forward, I need to import single unique keys and ignore the duplicates but retain their values. I am finding difficulty in accomplishing this
The above image shows the source data imported to numbered lists.
Point to note here - Long Description are texts and have length more than 100 hence concatenation is not working if used as code for non numbered lists.
The desired output is as below
Is there any work around to accomplish this.