Lookup & get returning vertically values

[Jhon Mustofa]

hi expert..

i need some formula to figure it out this following problem. With single lookup data get returning multiple vertically values...
and the name title as criteria..

please, see my attach file

i hope you could help me, and must be appreciated...

thanks in advance....

john m

[Jhon Mustofa]

ups, sorry i mean returning horizontally values...

[AlKey]

Please see attached file. This solution required a helper column.

[Jhon Mustofa]

Alkey, thank you very much....

it's magic like a charm.........(solved)

[AlKey]

You're welcome and thank you for the feedback!

[azumi]

Without Helper Columns.....

[Jhon Mustofa]

azumi,....great another way out.....

thank you...(matur nuwun, mas bro)