I've got a dataview (shown below)...
UDP Position Label Number
11042266 1 JXXXXX 9XXXXXXXXXXX
11042266 2 GXXXXX 9XXXXXXXXXXX
11042449 1 RXXXXX 11042458
11042458 1 SXXXXX 9XXXXXXXXXXX
11042458 2 IXXXXX 9XXXXXXXXXXX
11042458 4 AXXXXX 9XXXXXXXXXXX
11042458 5 HXXXXX 9XXXXXXXXXXX
11042458 6 MXXXXX 9XXXXXXXXXXX
11042459 1 IXXXXX 9XXXXXXXXXXX
11042459 2 SXXXXX 9XXXXXXXXXXX
you can see in the first column there is a field called UDP which has duplicates ...
what i need to end up with is a collection... probably an arraylist of comma seperated strings in the format...
but adds the fields Label and Number from the duplicates onto the string in the order of the position field: -
so the first UDP should show like this:
the 2nd should be:
the 3rd should be:
Hope this makes sense..
i've been trying do do it using loops but am running into difficulty...
Any advice greatly appreciated!