Reproduce the payroll dataset ensuring that every row has an employee name. For each row where the employee name is missing:

Look at the rows above to find the nearest mentioned employee name.
Use this employee name to fill in the missing name for the current row.
Extract the relevant details including the Pay Type and Pay Amount.
Return the reformatted table with the following columns:

Employee Name
Pay Date
Pay Type
Pay Amount


Payroll Details
10/01/2020 - 10/11/2020

Employee                  Pay Type                         Amt Taxes       Amt Deductions   Amt Company     Amt
NAME_1 NAME_2              Regular               37.67   $489.71 FIT      $46.53                 FUTA       $0.00
  Net $396.19             Prior Per Adj             0     $0.00 SS       $30.53                 SS        $30.53
  10/08/2020              Prior Period OT Adj       0     $0.00 Med       $7.14                 Med        $7.14
  DD                      OT                     0.14     $2.73 CA PIT    $7.13                 CA ETT     $0.00
  09/28-10/04                                                   CA SDI    $4.92                 CA SUI     $0.00

NAME_3          Regular               37.08   $482.04 FIT      $27.12                FUTA        $2.97
  Net $418.76             OT                     0.72    $14.04 SS       $30.75                SS         $30.75
  10/08/2020                                                    Med       $7.20                Med         $7.20
  DD                                                            CA PIT    $7.29                CA ETT      $0.49
  09/28-10/04                                                   CA SDI    $4.96                CA SUI     $16.87

NAME_4          Regular                  40   $560.00 FIT      $58.94                FUTA        $0.00
  Net $473.74             OT                     1.71    $35.91 SS       $36.94                SS         $36.94
  10/08/2020                                                    Med       $8.65                Med         $8.65
  DD                                                            CA PIT   $11.68                CA ETT      $0.00
  09/28-10/04                                                   CA SDI    $5.96                CA SUI      $0.00

NAME_5               38.91   $544.74 FIT      $35.63                FUTA        $0.00
  Net $474.50             OT                     1.06    $22.26 SS       $35.15                SS         $35.15
  10/08/2020                                  