I have this data, I did a union to generate the file like this

Main Number Type Invoice Number Amount Payment Date Payment Number
52837 13 365572 4000.00
52837 13 366643 5000.00
52837 24 XXXXX 9000.00 06/10/24 Check 123

Now I need to get the payment Date and Payment Number on the same line and eliminate the type of 24, so the result would be:

Main Number Type Invoice Number Amount Payment Date Payment Number
52837 13 365572 4000.00 06/10/24 Check 123
52837 13 366643 5000.00 06/10/24 Check 123

Any ideas on how to handle this?