Creating a payroll

Hi Anonymous ,

My original data table is like this:

Then, calculate :

GS = P3[ST] + P3[+SC]
GS-b = P3[GS] - P3[-BC]
KF1 = P3[GS-b] -P3[-M-C] 
KF2 = P3[KF1] - [-F-C] - [-C-C] - [-D-C] - [-C-C_1] - [-P-C] - [-Pr-C] - [-S-C] 
KF3 = P3[KF2] -[-Fix-C] 

Then, export the data and transpose in excel ( As you know, because of the calculated column, you can’t transpose in ‘Edit Query’ ):

Then, import the data and calculate the ‘sum’ and sort each row:

(My data’s sort is wrong, just for reference)

Best regards,

Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.