Finding multiple data values in a column

  • Thread starter Thread starter PeteJ
  • Start date Start date
P

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
 
Back
Top