Similar to the vlookup solution that does rows, I am interested to lookup rows and display as columns. (all matches)
INPUT
<tbody>
</tbody>
DESIRED OUTPUT
<tbody>
</tbody>Note the input is unsorted and the output is sorted
I played with the vlookup and rows/index match solutions for a bit, but couldn't work out how to transpose the output or sort it.
INPUT
StaffType | StaffMember |
Manager | Jane |
Worker | John |
Worker | Tom |
Manager | **** |
Worker | Harry |
Worker | Bob |
Worker | Joe |
<tbody>
</tbody>
DESIRED OUTPUT
Member1 | Member2 | Member3 | Member4 | Member5 | |
Manager | **** | Jane | |||
Worker | Bob | Harry | Joe | John | Tom |
<tbody>
</tbody>
I played with the vlookup and rows/index match solutions for a bit, but couldn't work out how to transpose the output or sort it.