Transform list into summary

[dwx]

Fruit Owner
Apple Jack
Apple Jack
Apple Jack
Apple Peter
Apple Peter
Orange Jack
Orange Peter
Orange Jack
Orange Peter
Grape Jack
Grape Jack
Grape Jack
Grape Peter

list with 2 columns, transforming into these 2 groups (top for Jack and bottom for Peter)

Apple 3
Orange 2
Grape 3

Apple 2
Orange 2
Grape 1

[MickG]

Try this:-
Results start "E1"

Please Login or Register  to view this content.

Regards Mick

[dwx]

Hey Mick,

some next level stuff here, it looks perfect.

thanks heaps!

[JieJenn]

Why not just go with Pivot Table

[dwx]

true, pivot table would definitely be more convenient.

But I was quite curious on how can this be done with macro and the procedure which MickG has done up has stuff that I have never come across before.

something to pick up here.

[MickG]

You're welcome