I want to populate a column, with text (and No null/blank values) from a column, based on an adjacent word found in third column. Please see the image below.
I would like the
Col A having values :
Giantsto be placed under the Giant Column (Column D)
Beesto be placed under the Bees Column (Column E) and so on.
Namesvalues for Bees and Titanic should begin in the first available cell in their respective columns.
On a side note, The actual list has over 150 names and 9 different teams of uneven quantities.
So, any ideas how can I proceed with ?