Consolidating Columns

[aashley]

I am trying to consolidate two columns of data so that they are identical. I will illustrate with an example to see if anyone can help me.

Here is how the current data appears on my report:

Open Orders			Shipped Orders
Item	Qty			Item	Qty
A	1			A	1
B	2			E	2
C	3			F	3
D	4			G	4
Goal is to get data like this:
Open Orders			Shipped Orders
Item	Qty			Item	Qty
A	1			A	1
B	2			B
C	3			C
D	4			D
E				E	2
F				F	3
G				G	4

<tbody>
</tbody>

What would be the best way to go about this?