Looking up and returning NON-unique text cells

[BWellman]

Hey all,
This is my first post, and wasn't sure whether it should go in general, VBA/Macro or formulas, as I don't even know where to begin.

I have a three-column text array, where the first column is made up of names, the second column is the company the individual works for and the third is the project they are on. The names are unique, there are two-possible options for company and eight possible projects the individual could be working on.

What I am trying to do is create groupings of all of the individuals working on particular projects, where if the "project" value in the array is changed, that individual is moved to the new relevant project.

For Example:

Data Set:

Column 1:
Mike Smith
Steve Kelley
Kelsey Ross
Bill Smith
Lindsey Hersch
Chelsey Hillup
Lindsay Rosser

Column 2:
PG
PG
PG
Shell
Shell
Shell
PG

Column 3: (I have a data validation by list in these cells where the values can only be 1 of 6 things)
M&A
PM
Supply Chain
Finance
M&A
Accounting
HR
Finance


Problem: I want the groupings to be shown as follows, where the lists will auto-populate if the data in column 3 is changed

Column 1:
M&A
Mike Smith
Lindsey Hersch

Column 2:
PM
Steve Kelley

Column 3:
Supply Chain
Kelsey Ross

Column 4:
Finance
Bill Smith
Lindsay Rosser

Column 5:
Accounting
Karl Lewis

Hopefully someone can help with this!
Cheers

[Pete_UK]

I don't fancy typing all that stuff in just to get started, so please attach your workbook - the FAQ describes how to.

Pete

[BWellman]

Excel_Help_File.xlsx

Thank's a lot. Sorry for the delay, I was away for the weekend. If there are any more questions, let me know.

[newdoverman]

Does this work for you?

[BWellman]

Perfect, thank you!

[newdoverman]

Thanks for the feedback.

[newdoverman]

Thank you for the feedback.