I need to extract aging report in one column rather than various columns.
Any suggestion as to how I can automate the extraction of existing aging
report?

Eg : Existing aging report (various columns)

column A - Debtors Name
column B - Debtors Number
column C - 30 days
column D - 60 days
column E - 90 days
column F - 120 days
column G - more than 120 days
column H - Total of columns C1 to G1 (Debtors Balance)

Column C to G refer to various debtor's aging period

Require format :

column A - Debtors Name
column B - Debtors Number
column C - Debtors Aging
column H - Debtors Balance