Strange request here. I have a report that shows the alias along with the item. However some items have more than one alias. So when I run the report some items are listed twice or more depending on how many aliases there are for that Item. What I want to accomplish is having this report show each item only once and have some formula in the Alias Column that only shows the UPC Barcode alias. Since all of these barcodes are 12 digits long I know that will be able to be used for the formula. However I do want all items to be listed even if they don't have a 12-digit barcode. So Items without a barcode will just have a blank alias in the report. Basically I want all items to show only once, and the items with a barcode show the barcode and items without a 12 digit barcode still show up but with no barcode under the alias column. Clear as mud. If anyone takes interest in this please let me know if you need any more information.
Thank you, Neil