How to merge multiple cell with the same dimension?

[fbukevin]

Hi all,

I have a table with two dimensions, "state_name" and "county_name", and one metrice. 

Since there are many county belongs to the same state, for example "Arkansas", I would like to show it just one time. That would be looks like 

Is it possible to merge all cells with the same dimension in Looker Studio? 
(I know it is possible by exporting to Google sheet...). 

[lauratilton · Accepted solution]

If you use a pivot table rather than a standard table, you can display the state once for the whole section (it's not actually "merging" anything, but I think this is what you're looking to do.)

https://support.google.com/looker-studio/answer/7516660?hl=en

[zohar]

Hi,  I'm facing the same issue. Using a Pivot table doesn't help me because my entire table consists of dimensions. Is there another way to merge cells in the table?