Hi

How do I achieve this in formula,


Customer Address E_mail
ABC Cone 700 W.ST 2RD
ABC Cone 700 W.ST 2RD
ACME 701 ACME DR
SANDALWOOD 200 SANDALWOOD AVE
SANDALWOOD 200 SANDALWOOD AVE
SANDALWOOD 200 SANDALWOOD AVE
DIGITAL TIMES 919 N MAIN ST
LUXURY SUITES 6616 DAVIS BLVD

LUXURY SUITES 808 E MAIN
LUXURY SUITES 6616 DAVIS BLVD
MISHMASH 350 MISHMASH PARKWAY

XYZ FOUNDATIONS 502 WEST LITTLE
XYZ FOUNDATIONS 123 MAIN
XYZ FOUNDATIONS 502 WEST LITTLE
XYZ FOUNDATIONS 502 WEST LITTLE
XYZ FOUNDATIONS 502 WEST LITTLE
XYZ FOUNDATIONS 555 SOUTH PENGUIN


Expected Result

Customer Address E_mail
ABC Concrete 700 W.ST 2RD
ACME 701 ACME DR
SANDALWOOD 200 SANDALWOOD AVE

DIGITAL TIMES 919 N MAIN ST
LUXURY SUITES 6616 DAVIS BLVD

LUXURY SUITES 808 E MAIN

MISHMASH 350 MISHMASH PARKWAY

XYZ FOUNDATIONS 502 WEST LITTLE

XYZ FOUNDATIONS 123 MAIN

XYZ FOUNDATIONS 555 SOUTH PENGUIN


TIA


--


Thank You

cheers, francis