Spreadsheet: 860190d1708389300-repeat-copy-paste-transpose-formula-excel-forum-post-2024-02-19
Sheet: Desired Format

Payroll Identifier | Employee Identifier | First Name | Last Name | Earning Code | Earning Description | Effective Start Date | Effective End Date | Amount | Percent | Frequency of Earning | Limit Value | Payee | Payee Value
9BG1 | Z0001111 | MOHAMAD | SMITH
9BG1 | Z0001111 | MOHAMAD | SMITH | OE02 - O/T-1.5 |  |  |  | 221.54
9BG1 | Z0001111 | MOHAMAD | SMITH | OE03 - O/T-2.0 |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OE07 - OTST |  |  |  | 18.46
9BG1 | Z0001111 | MOHAMAD | SMITH | OE43 - RETRODIR |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OE46 - GENPREM |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OE48 - FLOATDYS |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OE69 - IN LIEU |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OE71 - EVTN TKN |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OE91 - STAT HOL |  |  |  | 276.92
9BG1 | Z0001111 | MOHAMAD | SMITH | OEA5 - STATUTOY |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OEG4 - DENTAL1 |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OEH0 - MED QC |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OEH2 - PRESCRP |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OEH7 - TAXEQUAL |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OEI2 - INTERNET |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OEI9 - TXB CAR |  |  |  | 291.45
9BG1 | Z0001111 | MOHAMAD | SMITH | OEL7 - SBYFLATA |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OEM2 - SP PYMTO |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OEM3 - SPC ACH$ |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OEN1 - BNS TERM |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OEO0 - STKAWDCN |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OEO1 - 3I AWARD |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OEQ0 - ADJ REG |  |  |  | -276.92
9BG1 | Z0001111 | MOHAMAD | SMITH | OEQ1 - AUTOVAC |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OEQ4 - SLRSEE |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OEQ5 - SLEPEE |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OER0 - SLEPER |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OET6 - CASH TB |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OEV3 - RWRDPNTS |  |  |  | 0
9BG1 | Z0001111 | MOHAMAD | SMITH | OEW6 - NP BONUS |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME]
9BG2 | Z0002222 | KEVIN | [NAME] | OE02 - O/T-1.5 |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OE03 - O/T-2.0 |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OE07 - OTST |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OE43 - RETRODIR |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OE46 - GENPREM |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OE48 - FLOATDYS |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OE69 - IN LIEU |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OE71 - EVTN TKN |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OE91 - STAT HOL |  |  |  | 307.69
9BG2 | Z0002222 | KEVIN | [NAME] | OEA5 - STATUTOY |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OEG4 - DENTAL1 |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OEH0 - MED QC |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OEH2 - PRESCRP |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OEH7 - TAXEQUAL |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OEI2 - INTERNET |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OEI9 - TXB CAR |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OEL7 - SBYFLATA |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OEM2 - SP PYMTO |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OEM3 - SPC ACH$ |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OEN1 - BNS TERM |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OEO0 - STKAWDCN |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OEO1 - 3I AWARD |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OEQ0 - ADJ REG |  |  |  | -307.69
9BG2 | Z0002222 | KEVIN | [NAME] | OEQ1 - AUTOVAC |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OEQ4 - SLRSEE |  |  |  | 92.31
9BG2 | Z0002222 | KEVIN | [NAME] | OEQ5 - SLEPEE |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OER0 - SLEPER |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OET6 - CASH TB |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OEV3 - RWRDPNTS |  |  |  | 0
9BG2 | Z0002222 | KEVIN | [NAME] | OEW6 - NP BONUS |  |  |  | 0