Want data of field 1 and field 2 but if there is same value in field 2 then output Sequenced data. Please see the attached file it contains desired output as well. Kindly help
there are multiple ways and it totally depends on the requirement
but I suggest using the sample tool.