Hi,

I have a table that contains data similar to the below, apologies for the table layout:

employee_number balance_name balance_value
a1 Gross Pay 100
a1 Total Deduction 50
a1 Total Pay 50
b2 Gross Pay 50
b2 Total Deduction 50
b2 Total Pay 0
c1 Gross Pay...