Finding multiple data values in a column

[PeteJ]

I have a set of data with Account Name in column A, and related values in
Column B, comma separated. Is there an easy way to find all the unique values
in Column B and associate an account name to them?

For instance, Row 1 has "Account A" in column A, and "Issue 1, Issue 2" in
column B". Row 2 has "Account B" in column A, and "Issue 2, Issue 3" in
column B. I'd like transpose, and get a list that says:

Issue 1 Account A
Issue 2 Account A, Account B
etc.

VLOOKUP doesn't work, since it returns only a single value. Would an array
version work?

Thanks,

Pete

 

[Herbert Seidenberg]

Excel 2007 Tables
Advanced Transpose
http://www.mediafire.com/file/tti12omn5g2/09_15_09.xlsx

 

[PeteJ]

Awesome Herbert, exactly what I was looking for.

Thanks.

Pete