Creating a payroll

[Anonymous]

I have a problem with creating my payroll
At the end I want to get the following table:

My data has been imported into the program in this format:

The problem has always been that I do not have my own table in which the desired terms (Sales Turnover, Surcharge C, etc.) are associated with the values.

How do I get it now that I choose the column header as a row heading without first changing it in the Power Query Editor? I can not find a visual that offers me this feature.

Another possibility would be to create my own table in which I create a list (Sales Turnover, Surcharge C, etc.) and then link them to values from another table.

Best regards,

Frank

[v-lionel-msft]

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.