Hello All,

I have a table which has several text columns and some numbers columns.

I am trying to group it as you can see on the image, but I cannot do it in a manner that would allow me to keep the text data in columns rather than below the main group. In this example, the columns "Pais" and "IGPM+6% " supposed to stay in columns rather than in the breakdown. I found some suggestions that would be convert the text to numbers, put it in a pivot table, apply conditional formatting and replace the numbers with the former text value. It does work but I have several data and to maintain this kind of approach would be almost impossible.

Does anyone has some suggestion to do it in another simple way?

Excel.PNG

Thanks in advance.