Pivot - not pivot (table of employees, tasks etc. in groups)

I have a table

Name	type
Name1	a/c
Name2	a/d
Name3	b/c
Name4	b/d
Name5	a/c
Name6	b/d

Need to list the names in (dynamic) table like this:

	c	d
a	Name1 Name5	Name2
b	Name3	Name4 Name6

A bit like pivot, but without calculations - just list of names in each group.

For excel 2010 or even 2007

Any sugestion (pls checked, not "i suppose" )