Macro to sort data range

Hi folks

Back again with more excel woes

I'm carrying out some equine pedigree research. I've attached my sheet as it may make it easier to understand, In cells B3 to B22 I've pasted in some information. This is not split between columns after it was pasted. What I would like to achieve is create a macro to split this information and present parts of it as I have typed in from cells L3 across to cells U3. I just typed in 3 horses there for demonstration purposes to show how I want it to look, but I would like to be able to run something on cells B3:B22 that would present all the horses information from Sea the Stars all the way down to Giants Causeway as such.

I did attempt to try split the pasted information by using the "text to columns" function but it turned out rather messy and all mixed up,if that had of worked I was intending to just simply record a macro,shortcut ctrl d, to do what I need but then I would run into issues with active and selection cells and the macro would not run correctly. I'm not very experiences running macros to be honest.

Any help or advice at all would be greatly appreciated

Thanks
Steve

Hi Bogdan

That is perfect!! exactly what I wanted!!! and thanks for including the code too so I can see how it was done..

This will help me immensely going forward!!

Cheers
Steve