Hi,
I realise that this is probably a very simple problem but I can't find a solution so am posting it here.
I have a Excel 2007 spreadsheet with species names in the first column (A) and occurrence codes in the following five columns (B-F).
Where there are duplicate species names in column A I would like concatenate the occurrence codes into one row and delete the empty rows.
Attached is a example of the my current data and desired output.
Thanks in advance for any help
Bookmarks