how to add up the same row id to different columns

[yanm11]

hey,
thanks to anyone who is willing to help.
this is the raw data:

then after changing a bit the data with vba i get it to this format:

now the problem here its that we get the same employee number for a few rows.
so instead of having one row for number 1111111 and three columns with the salary we get three differenet rows.

this is how i want it look:

A few notes, the number of columns is changing every month and so is the number of rows. my macro brings it to this format but i need one that continue and agragate the rows.

thanks a lot to those who help.

 

[Legacy 143009]

It is very difficult to say something without seeing the code.
You must loop through each employee number column at Table 2 on each iteration to check if you are writing data for the same employee or not.
If it is the same employee number, then, stop there and write your data there. If not, continue iteration and write to new row.