Data comes out of the source in the format below with batch, ID, Item Number, and Material cost all on one row and associated description and labor costs on the next row. Example below:
Batch | ID | Item Number Description | Material Labor |
| 100001 | 2001 | 3000000001 | 100.00 |
| | | Apples | 50.00 |
| 100002 | 2002 | 3000000002 | 200.00 |
| | | Oranges | 60.00 |
How can I add and populate two additional columns to every other row that contain the description and labor information from the second line of the data and then delete the second line?
Desired result:
Batch | ID | Item Number | Material | Description | Labor |
| 100001 | 2001 | 3000000001 | 100.00 | Apples | 50.00 |
| 100002 | 2002 | 3000000002 | 200.00 | Oranges | 60.00 |
