How to create multiple columns using data from the filter function in Google Sheets

I just started using google sheets to help edit tables for a database and I need some help creating a function. In ColumnA, I've got a list of MovieID's, in ColumnB, there is a list of directors, and in ColumnC, there is a list of unique directors from ColumnB. I'm trying to filter the data and create a set of columns where in one, there is the director's name and in the other, there's the movieID that corresponds to a film the director was involved in.

Ive created a function in F2 to find the ids for a director, and I can just drag the formula down (when the data is transposed, and the C2 value will shift to C3, C4....) But, I want the name of the director to be included in the column to the left of the filtered results (like I've manually done in E), but I can't really figure it out, and I'm not entirely sure on how to use the other functions to get it right.

Any help or guidance on how to achieve this would be greatly appreciated!!

https://stackoverflow.com/questions/67029577/how-to-create-multiple-columns-using-data-from-the-filter-function-in-google-she April 10, 2021 at 07:54AM