Transpose duplicate customer email addresses from rows, to single row, multiple columns

I am unable to explain as it is not allowing me to post whole detail.

Check the attached file

A similar solution, also providing you with a unique list of customers.

Unique customer list (array formula) in F2, copied down:
=IFERROR(INDEX($A$2:$A$7,MATCH(0,INDEX(COUNTIF($F$1:$F1,$A$2:$A$7),0),0)),"")

Email addresses, array formula, in G2, copied across and down:
=IFERROR(INDEX($B:$B,SMALL(IF($A$2:$A$7=$F2,ROW($A$2:$A$7)),COLUMNS($A:A))),"")

Array Formulae are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...

I've just noticed that your profile states that you're using Excel 2003. If so, use this in F2
=IF(ISERROR(INDEX($A$2:$A$7,MATCH(0,INDEX(COUNTIF($F$1:$F1,$A$2:$A$7),0),0))),"",INDEX($A$2:$A$7,MATCH(0,INDEX(COUNTIF($F$1:$F1,$A$2:$A$7),0),0)))

and this in G2:
=IF(ISERROR(INDEX($B:$B,SMALL(IF($A$2:$A$7=$F2,ROW($A$2:$A$7)),COLUMNS($A:A)))),"",INDEX($B:$B,SMALL(IF($A$2:$A$7=$F2,ROW($A$2:$A$7)),COLUMNS($A:A))))

array entered as before.

Great! I'm glad to have helped! If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

You could use a bit of VBA to provide the unique customer list - much quicker than any array formula. Interested?