Spreadsheet: 73607d1274253324-extract-one-unique-information-for-each-record-data1
Sheet: Data

CONTRNO | Customer ID | PAIDLOC | EOM_PASTDUE | PAYMENT | SUB_STATUS | Payment Date | CATEGORY | CCAT | SCR_CLASS | PRE_POST | BS_TYPE
935076 | 99939926 | 26.538 | 49.838 | 49 | CONN | 2010-05-09 00:00:00 | PKU | LOW | I | POST | VOICE
935076 | 99939926 | 22.462 | 49.838 | 49 | CONN | 2010-05-09 00:00:00 | PKU | LOW | I | POST | VOICE
315228 | 97453149 | 13.1 | 26.6 | 26.6 | CONN | 2010-05-09 00:00:00 | PKU | [NAME] | ID | POST | DATA
315228 | 97453149 | 13.5 | 26.6 | 26.6 | CONN | 2010-05-09 00:00:00 | PKU | [NAME] | ID | POST | DATA
315228 | 97453149 | 0 | 26.6 | 26.6 | CONN | 2010-05-09 00:00:00 | PKU | [NAME] | ID | POST | DATA
224581 | 97511325 | 14.806 | 29.806 | 30 | CONN | 2010-05-09 00:00:00 | PKU | CC_DATA2 | BD | POST | DATA
224581 | 97511325 | 15 | 29.806 | 30 | CONN | 2010-05-09 00:00:00 | PKU | CC_DATA2 | BD | POST | DATA
458561 | 99025078 | 4.83 | 134.83 | 135 | CONN | 2010-05-09 00:00:00 | PKU | LOW | I | POST | VOICE
458561 | 99025078 | 0.17 | 134.83 | 135 | CONN | 2010-05-09 00:00:00 | PKU | LOW | I | POST | VOICE
213412 | 97339358 | 2.769 | 18.369 | 19 | CONN | 2010-05-09 00:00:00 | PKU | MEDIUM | I | POST | VOICE
213412 | 97339358 | 4.36 | 18.369 | 19 | CONN | 2010-05-09 00:00:00 | PKU | MEDIUM | I | POST | VOICE
213412 | 97339358 | 4.56 | 18.369 | 19 | CONN | 2010-05-09 00:00:00 | PKU | MEDIUM | I | POST | VOICE
213412 | 97339358 | 6.68 | 18.369 | 19 | CONN | 2010-05-09 00:00:00 | PKU | MEDIUM | I | POST | VOICE
213412 | 97339358 | 0.631 | 18.369 | 19 | CONN | 2010-05-09 00:00:00 | PKU | MEDIUM | I | POST | VOICE
781730 | 97373579 | 9.34 | 77.887 | 70 | CONN | 2010-05-09 00:00:00 | CS2 | LOW | B | POST | VOICE
781730 | 97373579 | 35.985 | 77.887 | 70 | CONN | 2010-05-09 00:00:00 | CS2 | LOW | B | POST | VOICE
781730 | 97373579 | 24.675 | 77.887 | 70 | CONN | 2010-05-09 00:00:00 | CS2 | LOW | B | POST | VOICE
071760 | 99505400 | 37.024 | 56.884 | 42 | CONN | 2010-05-09 00:00:00 | PKU | LOW | I | POST | VOICE
071760 | 99505400 | 4.976 | 56.884 | 42 | CONN | 2010-05-09 00:00:00 | PKU | LOW | I | POST | VOICE
464639 | 99367423 | 0.29 | 54.29 | 54 | CONN | 2010-05-09 00:00:00 | PKU | CC_DATA2 | MD | POST | DATA
464639 | 99367423 | 27 | 54.29 | 54 | CONN | 2010-05-09 00:00:00 | PKU | CC_DATA2 | MD | POST | DATA
464639 | 99367423 | 26.71 | 54.29 | 54 | CONN | 2010-05-09 00:00:00 | PKU | CC_DATA2 | MD | POST | DATA
192978 | 99052998 | 58.401 | 119.414 | 119.5 | CONN | 2010-05-09 00:00:00 | CS2 | LOW | M | POST | VOICE
192978 | 99052998 | 61.013 | 119.414 | 119.5 | CONN | 2010-05-09 00:00:00 | CS2 | LOW | M | POST | VOICE
192978 | 99052998 | 0.086 | 119.414 | 119.5 | CONN | 2010-05-09 00:00:00 | CS2 | LOW | M | POST | VOICE
997387 | 99993621 | 65.06 | 140.23 | 141.6 | CONN | 2010-05-09 00:00:00 | PKU | [NAME] | B | POST | VOICE
997387 | 99993621 | 75.17 | 140.23 | 141.6 | CONN | 2010-05-09 00:00:00 | PKU | [NAME] | B | POST | VOICE
997387 | 99993621 | 1.37 | 140.23 | 141.6 | CONN | 2010-05-09 00:00:00 | PKU | [NAME] | B | POST | VOICE
663494 | 97512523 | 12.68 | 26.5 | 26.5 | CONN | 2010-05-09 00:00:00 | PKU | CC_DATA2 | BD | POST | DATA
663494 | 97512523 | 13.82 | 26.5 | 26.5 | CONN | 2010-05-09 00:00:00 | PKU | CC_DATA2 | BD | POST | DATA
1-There is a duplicate records the above data shown in Column (A, B, D, E, F, G, H, I, J, K & L)
What is required:-
We need to write a formula in order to get only one unique information for each record, the result should be similar to the below output:-
CONTRNO | Customer ID | PAIDLOC | EOM_PASTDUE | PAYMENT | SUB_STATUS | Payment Date | CATEGORY | CCAT | SCR_CLASS | PRE_POST | BS_TYPE
935076 | 99939926 | 26.538 | 49.838 | 49 | CONN | 2010-05-09 00:00:00 | PKU | LOW | I | POST | VOICE
315228 | 97453149 | 13.1 | 26.6 | 26.6 | CONN | 2010-05-09 00:00:00 | PKU | [NAME] | ID | POST | DATA
224581 | 97511325 | 14.806 | 29.806 | 30 | CONN | 2010-05-09 00:00:00 | PKU | CC_DATA2 | BD | POST | DATA
458561 | 99025078 | 4.83 | 134.83 | 135 | CONN | 2010-05-09 00:00:00 | PKU | LOW | I | POST | VOICE
213412 | 97339358 | 2.769 | 18.369 | 19 | CONN | 2010-05-09 00:00:00 | PKU | MEDIUM | I | POST | VOICE
781730 | 97373579 | 9.34 | 77.887 | 70 | CONN | 2010-05-09 00:00:00 | CS2 | LOW | B | POST | VOICE
071760 | 99505400 | 37.024 | 56.884 | 42 | CONN | 2010-05-09 00:00:00 | PKU | LOW | I | POST | VOICE
464639 | 99367423 | 0.29 | 54.29 | 54 | CONN | 2010-05-09 00:00:00 | PKU | CC_DATA2 | MD | POST | DATA
192978 | 99052998 | 58.401 | 119.414 | 119.5 | CONN | 2010-05-09 00:00:00 | CS2 | LOW | M | POST | VOICE
997387 | 99993621 | 65.06 | 140.23 | 141.6 | CONN | 2010-05-09 00:00:00 | PKU | [NAME] | B | POST | VOICE
663494 | 97512523 | 12.68 | 26.5 | 26.5 | CONN | 2010-05-09 00:00:00 | PKU | CC_DATA2 | BD | POST | DATA