Moving Cell Info and Deleting Row

[dfurn]

Good morning,

I have a report that generates an excel workbook with two rows of data for each purchase order line, one line for amount ordered and another for amount received. This is a canned report from the software that we use, and I have no method of changing that code.

On the attached spreadsheet, I've provided a scaled down version. There are thousands of rows. I'd like the information in cells A3 and B3 moved to A2 and B2 and then have the empty row deleted.

[ChemistB]

Using formulas on a new sheet
In A2 copied to B2 and down

=IFERROR(1/(1/INDEX(Sheet5!A$2:A$104857, ROWS($A$1:$A1)*2)),"")

In C2 copied to D2 and down

=IFERROR(1/(1/INDEX(Sheet5!C$2:C$104857, ROWS($A$1:$A1)*2-1)),"")

You can do a copy > Paste Special>Values to remove the formulas afterwards