Dear all,

Understand that we can use an array formula (Ctrl + Shift + Enter) to vlookup multiple values for the following Raw Data:

Raw Data
A 15
B 15
C 20
A 20
A 25
A 26
B 27

Formula as follows:
=INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)),2)

Results:
A 15
20
25
26

However, is there a way to drag the results horizontally instead of vertically?
I want it to look like this:

Results
A 15 20 25 26
B 15 27
C 20

Please help!! Much appreciated!