Split Collums by Category

cc267

New Member
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

MrExcel MVP, Moderator
Welcome to the MrExcel board!

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

cc267

New Member
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.
 

Some videos you may like

This Week's Hot Topics

Top