SOLVED

Merged Cells and Filtering

New Contributor

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

 

Job

A1
A2
A3
B1
B2

I want to merge like values in the first column

then run a filter formula

Call these A:6 and B:6

JobA

=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?

4 Replies

@MatthewO2147 

FILTER doesn't work that way.

best response confirmed by MatthewO2147 (New Contributor)
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.

Screenshot 2022-03-22 at 06.09.56.png

I ended up doing something similar, thank you

@MatthewO2147 

harshulz_0-1647952839962.png

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

and then filter it