Macro to Clear Cells and form a table out of it

[Nikhil76]

Column A Column B Column C Column D Column E Column F Column G Column H
Purch Locn Blank 1 Sub Locn Blank 2 No. of Unmatched Receipts/Returns Pur Loc Blank 3 Receipts
AASS
ACH 2
Subtotal for Purch Locn AASS 2
ACH
STOR 3
Subtotal for Purch Locn ACH 3
ACON
AIT 8
Subtotal for Purch Locn ACON 8
AITA
AIT 4
Subtotal for Purch Locn AITA 4
AMPL
CAIN 3
CBAR 1
CBDW 2
1. This is the raw report but has more lines
2. I need a table with values from column C with a corresponding value from column E
3. I also need another table from column F with a corresponding value from column H
4. The table should look like below -
Sub Locn Value Pur Loc Receipts
ACH 2 AASS 2
STOR 3 ACH 3
AIT 8 ACON 8