Transpose cells in a column if adjacent criteria matches

[Knockoutpie]

Kind of difficult to explain this in a header..

I'm trying to take a column of employee names, and if the title matches "sales" to transpose those names to a header..

This is the ideal output.. Trying to figure, maybe it's a mix of filter, unique, transpose, index, match, etc. Any help would be great.

Employee 1

Employee 2

Employee 4

Employee 5

Employee 8

Employee 9

Name	Title
Employee 1	Sales
Employee 2	Sales
Employee 3	Purchasing
Employee 4	Sales
Employee 5	Sales
Employee 6	Purchasing
Employee 7	Purchasing
Employee 8	Sales
Employee 9	Sales

 

[Fluff]

How about

=TOROW(FILTER(A2:A100,B2:B100="Sales"))

 

[Knockoutpie]

How about

=TOROW(FILTER(A2:A100,B2:B100="Sales"))

It works for this example, and that's the concept i'm going for, but for my real use it doesn't work for some reason.

I have a table that's 12000 rows long in Sheet1. This returns #N/A for me in Sheet2, I figured maybe it's because there's too many records and I need to include Unique in it but still no dice.

 

[Fluff]

Do you have any cells with #N/A in the data?

 

[Knockoutpie]

Do you have any cells with #N/A in the data?

Thanks Fluff, you're the best.

Had to edit my query which pulls from my database to remove lines with #N/A

 

[Fluff]

You're welcome & thanks for the feedback