Hi
I have an excel sheet with Column a being a name.
Column B is a title
Some Names have 2 titles and some have 3 or 4.
The titles are put on separate rows.
I can use the concatenate formula to merge the rows but the list is very long and Id like a formula to, say
Pick which Column (name) has 2 rows then apply concatenate formula One
Pick which Column (name) has 3 rows then apply concatenate forumla two.


Etc ....... any ideas would be most appreciated.....