Split Collums by Category

[cc267]

Hi everyone, I need the example below to look like the example right of the arrow.

I only want to take the Ashleigh data and all the numbers under Ashleigh and have that data to the side.

Can anyone help me understand how to do this?

 

[Peter_SSs]

Welcome to the MrExcel board!

Are you looking to do this ..
a) Manually
b) By formulas
c) By macro

 

[cc267]

Either B or C but each person I'm looking to extract - they will have different numbers under their name each time - sometimes it could be three numbers, sometimes four. And I'm looking to implement this as fast as possible so depends on if formulas are faster and easier to implement on the data set than macros.