Forum Discussion
Merge cells across multiple rows when values are the same
I'm trying to combine/merge cells when the values are the same for a given column. This is most easily explained with some example tables: What I have now: What I'm trying to make it...
Anonymous
add three columns in the rows field and expand all
2. turn off stepped layout and +/-icon
3. turn off row subtotal
pls see the attachment below
This is great but now I'm not able to do specific column conditional formatting in the "columns". Is there a way to have the background of the columns different or do a similar merge in tables vs matrix? I need background colors on the first two columns of the matrix but only see this option in the table visualization menus.