Can anybody help me with the next problem.
I have an Excel file wich is like folowing :

A B
Name 1 problem1
Name 1 problem2
Name 1 problem3
Name 2 problem1
Name 2 problem2
Name 3 problem1

and so on ....

I have to seperate each name with more columns where the "problems" reside.
So :

A B C D
Name 1 problem1 problem2 problem3
Name 2 problem1 problem2
Name 3 problem1

Anybody a solution to do this automaticly with an formula or macro.
I have about 2000 names !!!

Thanks in advance (I am using Excel 2000)
Jeroen