condensing rows

[onsga006]

How would I condense the rows so that the sum expense for each country is in the same row as the manager and team size for each country?

[AngelosPachis]

Hi @onsga006,

You can try using a transpose tool and select the Country field as a Key column.

Then with a filter tool, you can select to exclude the null values under the [Value] field (Value is not empty would work as well).

Finally with a crosstab tool, select to group by country, column headers to be under the [Name] field and the values for the new columns to originate from the [Value] column. Method of aggregation can be "Concatenate".

I believe this will do what you are looking for.

Best,

Angelos