VB Code to clean up Payroll Data by deleting rows

Hello:

Please refer to attached file.
I have data as shown in Sheet1 and it needs to be transformed as shown in Sheet2

Basically, need VB code to look for ", in Column B,\
if Found then copy Data from next row column C into Column C above arow

In this case I would copy Cell C3 to Cell C2
So now you have B2 = Name of employee, C2= Amount $2500 and D2 = 03/31/20

And this needs to go thru the whole sheet and delete the rows in between

I have shown completed manually in Sheet2.

Please let me know if you have any questions.
Thanks.

R




Let me know if you have any questions.
Thanks.