Excel 2007 : Combining rows into one

I have customers that have several account numbers, I have given an example below.

I need to combine the all 3 lines into one row, but copying the account numbers into one cell, with a "," seperating each one if possible in Cell A1 - I need this as im importing the final output into a outlook contact cards.

A B C D E F
1 2781645 Mr Mark Hollinger LONDON W11AA 00240662 00001111
2 2781644 Mr Mark Hollinger LONDON W11AA 00240662 00001111
3 2781643 Mr Mark Hollinger LONDON W11AA 00240662 00001111

This I have across 6800 lines, I dont particulary want to use a filter and copy and paste.

Is there a VB/Vlookup that can do this?

Also.. is it possible to Count the amount of accounts one person has and tally this up in a seperate cell? I.E Column N? :-)

The A,B,C etc as you can probably see is messed up - For some reason it looks ok on editing, just not when its saved...


Many thanks

Darren

upload a sample workbook with sample data and your desired results

In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button