Hi all,

I have a question.
I have a dataset like the left table in my screenshot (small example). In this dataset, there are different combinations between origin and destination which each the number of employees working in each sector and the total listed.
Now I want to transform/reshape this dataset to the right table, where each origin is listed only once. For this origin, now the sum of all destinations that belong to that origin are listed.
The variables remain the same (S1, S2, S3, S4, S5, Total)

Thank you in advance!

Romy

Array