Condense two lines of related data into one line

[jpavlick]

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

[JosephSerpis · Accepted solution]

Hi @jpavlick I mocked up a workflow let me know what you think?