2 column table to multiple columns table

[CNOPPE]

Hi all -

I have a 2 column table (which shows under "start" in the example file) which i'd like to automatically transform into a multi column table with the data from the original table. I know my explanation might seem a bit confusing but I hope it will be clear in the example file. I've tried using query and Vlookup functions, but nothing so far works. Could anyone please help me out?

thanks very much

kr
charly

[PaulM100]

This should do:
Array formula. pres Ctrl+Shift+Enter simultaneous to insert it

=IFERROR(INDEX($B$5:$B$13,SMALL(IF($A$5:$A$13=D$12,ROW($A$5:$A$13)-ROW($A$5)+1),ROWS($A$5:A5))),"")

[CNOPPE]

Thank you very much!