Forum Discussion

MatthewO2147's avatar
MatthewO2147
Copper Contributor
Mar 21, 2022
Solved

Merged Cells and Filtering

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...
  • Riny_van_Eekelen's avatar
    Mar 22, 2022

    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.

Resources