Hello friends,

I have a very long list in column A that looks like the example bellow. The actual list is long and random and has many spaces between the cells that contain information.

Example:

A25 = Client Number123456789
A36 = Client NameMickeyMouse
A45 = Type of BusinessBarber Shop
A49 = RegionEast
A56 = Phone Number123-456-7890

I have been trying to find a way to automatically search let's say Client Number and return his number 123456789 and place it in B1
Search Client Name and return MickeyMouse and place it (MickeyMouse) in B2
and so on...

Result wanted:
B1 = 123456789
B2 = MickeyMouse
B3 = Barber Shop
B4 = East
B5 = 123-456-7890

Could you please help me with a VBA Code that can do this.

Thanks a lot in advance
Claudia