[Solved] Filter Command to pull all data

[goodmanjl531]

I am trying to set up a filter to lokk down list and give me ever row that matches it

3	15
3	25
3	925
10	31
11	33
12	34
12	50

so if i now have a row with the following

3

10

12

would put in my filter forumla to get below

3	10	12
15	31	34
25		50
925

I have tried using the filter formula but get extra data repeating the search data every time.


Any help would be greatly appreciated
this is formula that i place in A12 =FILTER(A1:B7,A11=A1:A7

also this will be a large Array with about 4000 rows and my lookup column is about 100 cells
.

 

[shamimarita]

Hello,

To filter your data in a specific format where each unique number in the first column has its corresponding values aligned in different columns, you can use the following formula.
Formula:
=FILTER(B$1:B$7, A$1:A$7=$A11)
=FILTER(B$1:B$7, A$1:A$7=$B11)
=FILTER(B$1:B$7, A$1:A$7=$C11)
OR
=IFERROR(HSTACK(FILTER(B$1:B$7, A$1:A$7=$A11), FILTER(B$1:B$7, A$1:A$7=$B11),FILTER(B$1:B$7, A$1:A$7=$C11))," ")

Download Excel file: