I have a CSV file that has one Bac being matched to many different VINS. Some of the records are duplicates.
For example:
_______________________________
BAC 10 VIN 1
BAC 10 VIN 2
BAC 10 VIN 3
BAC 10 VIN 4
_________________________________
I would like to print a form that has BAC 10 at the top, and a list of VINS below. How can I do that and still remove his duplicate names and duplicate addresses? I would like to end up with this:
____________________________
BAC 10
VIN 1
VIN 2
VIN 3
VIN 4
____________________________
I already tried putting an advanced line condition on the VIN. But it is not listing the many vins to the one bac. Also, do I need a condition on the bac? I basically want one info sheet sent to bac 10 with all his vins listed on it.
Thanks!
