How to group by two columns in excel so that each row contains both values?

Question

excel

If you group through the pivot table by dragging these 2 columns to the rows area, then it is grouped, but not in the SQL style, as we would like ... Namely, it is necessary that each row contains both values ​​in the grouping columns. How to do it?
An example of grouping by two fields:

Answer 1

An example would make it clearer.
I would venture to suggest that creating an intermediate field will help you, in which the values ​​\u200b\u200bof the fields you need will be combined.