I have 2 sheets in workbook. On sheet1 I have values in 2 columns, such
as:

Name Type
test1 A
test2 B
test3 A
test4 A
test5 B

On sheet2 I would like to summarize the information by Type, such as:

TypeA TypeB
test1 test2
test3 test5
test4

What formula can I configure on sheet2 to acquire this result?
Thanks!


--
rerhart
------------------------------------------------------------------------
rerhart's Profile: http://www.excelforum.com/member.php...fo&userid=8138
View this thread: http://www.excelforum.com/showthread...hreadid=570905