DATA MANIPULATION (3)

I have an openoffice calc spreadsheet with 2 columns and 7000+ lines Each line contains a product id in the first column and a colour in the second column. I need 1 line only for each product id. To achieve this the second column should contain a list of the colours, with each colour seperated by a colon. Example id colour 42 white 42 black 52 green 52 red 52 orange Required example 42 white:black 52 green:red:orange ## Deliverables 1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement). ## Platform N/A