Concatenate cells? and delete duplicates

Hi there, I'm a newbie and I have an excel 2007 spreadsheet that I would like to merge the values from 3 columns against the common company name and then delete duplicate company names from (column A) - Don't know if im explaining properly, but i have attached example of what i have vs. what i would like as a result.

I need to identify the duplicates, concatenate the "3 Columns values (Currency, Year and Total)" to the appropriate company the first row, and delete the duplicate company I guess...???

Any help on how to do this would be greatly appreciated!

I'll look at your sheet. Meanwhile, read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to EDIT that post above ...GO ADVANCED and then correct the title.

Thread titles are unemotional descriptions of the topic, appropriate to a Google Search.

Also, does your sample data represent your ACTUAL layout? Do the titles of the table appear in row 3 and data starts in row 4? Or are the titles in row 1, more common?

Scorp, I have a macro ready for you to test...fix that first post title so we can get it posted.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Edited this time

Thanks Roy.

Scorp, take out the blank rows at the top of your data so the titles are on row1, the data in row2. Then try this macro:

Please Login or Register  to view this content.

Thanks JBeaucaire, the code worked and I am so pleased - but now i have a new sheet that requires the same type of thing, but dont really understand how to edit the code so that it works for this attachment (see new attachment)...

The company is the main identifier and need to merge columns C D E F G H I J K L M and S T U V W X into the row with Columns N O P Q R, if that makes any sense.

Urgh Excel!