Split Collums by Category


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?



MrExcel MVP, Moderator
Welcome to the MrExcel board!

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


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