Hi!

I have a question about transforming my data table.

I have a table with 3 variables: postal codes (PC4), the number of available jobs (AvailableJobs) and the sectors in which the available jobs can be categorized (Sector). A small example I made in Excel of my data can be seen in the left table.
Now I want to convert/transform this left table to a table like the right table. Instead of a table with all separated observations (left), I want a table in which all available jobs per PC4 are added together and are divided over the mentioned sectors. So in fact the column G is the sum of columns H through N.

Can someone tell me if this is possible? And if so, which comments do I have to use?

Thank you in advance!



Array