SSRS How to display only one row in groups column

Question

I'm making a RS but I can't find on how to display only one cell for the group column.

The upper report is what I'm making and I want my report to be look like the bottom report

![The upper report is what I'm making and I want my report to be look like the bottom report]1

Also is there a way to edit the report again. I mean to display the Report Wizard again and assign if either the column is gonna be page,groups or details

Edit 1:

I tried deleting the columns and adding group manually. But the output is wrong The column [Agent Name] is the only drillable column, you can refer to the image.

Answer 1

You have to delete all the groups/rows except the bottom (details row), then add the groups back, but when adding them select the 'Add Group Header' checkbox - This will create the merged cells...

Alternatively, select the cells you want merged (with control+click), then right click one and merge them

After manually creating the row group. You have to go to row group properties>Visibility>Select the 'hide'>Check the 'Display can be toggled by this report item:' and select the column group.