I have a Google Sheet https://spreadsheets.google.com/ccc?key=0ApGg6c9aeywQdExrZjBzUnRER25KSUQxRTBJTDRObXc&hl=en&authkey=CI3z8Y8D#gid=0
In this sheet, I want to combine the data in Col E and Col G for all the duplicates.
I want only one entry with Col E data combined and Col G data combined. The data from different cells should be separated by a semi colon and a space.
Can this be done?