If the solution offered satisfies your requirement then I'll bow out. If not I'm happy to help with some VBA code.

A few questions.

1. You say the list is long and 'random'. Is all the information for one client lumped together?
In other words, can I be sure that if I find a client number in the list, then the very next phone number (for example) belongs to that client?

2. Is the 'order' consistent (ie. does Client name ALWAYS follow the client number, albeit with some other stuff in between that you are not interested in)?

3. Are those 5 things the only information that exist for each client or the only 5 things you want to store in column B?

4. Can you mock up a small example so that we can see the type of 'randomness' that exists, what you expect from the VBA code and attach it to your post?