Merged Cells and Filtering

[MatthewO2147]

I'm trying to merge cells in Column A and then use a filter to display all cells next to it.

Job

A	1
A	2
A	3
B	1
B	2

I want to merge like values in the first column

then run a filter formula

Call these A:6 and B:6

Job

A

=filter(A1:B:5,A1:A5=B6)

So I could receive and output like

A         1

           2

           3

Is there any way to do this with the merged cells referencing all cells adjacent to the merged cell?

[#2]

@MatthewO2147 

FILTER doesn't work that way.

[#3 · Accepted solution]

@MatthewO2147 You could  filter only the second column based on the Job and add a label for the Job (in A11) by directly linking it to the selected Job cell reference (C9), as shown in the picture below.

[#4]

I ended up doing something similar, thank you

[#5]

@MatthewO2147 

to merge cell use formula
=concat(text1,text2)

and then filter it