Hello,

I am trying to find a formula similar to Vlookup/Hlookup. I think it will be similar to a Index as well. Basically I have Two columns that are update weekly. Column A is a list of Dates, Column B is a list of team members (where team members are repeated).

I need to create a table where the Team members name will be a header all all dates that match the team member will be listed. I know I can just put a filter then copy and paste them over, but I was hoping for a formula that would automatically do that since there's about 300 lines that are updated weekly.

I attached a screenshot of an example. The Green box is where I am looking to put the formulas.
ScreenHunter_10.jpg