Rearranging Datewise horizontally in a specified format from Raw data

Hi,

As enclosed in my sample data , I have a Data Sheet in which raw data exist.From this data,I want to arrange data in the format which is shown in "Result"sheet.Following things should be extracted

Column A (Date) of result sheet should be extracted from Column A(Date) of Data sheet

Column B (Name of Party) of result sheet should be extracted from Column C (Particulars) corresponding to the entry of Column I(Credit) of Data sheet

Column J (Total) of result sheet should be extracted from Column I (Credit) of Data Sheet & must be corresponds to Column B (Name of Party) of result sheet.Only numeric data should be taken.

Column C (Particulars) of result sheet should be extracted 1 row below of "as per details" of Column C from Column C(Particular) of Data sheet

Column E (Taxable Purchase) of result sheet should be extracted from Column H (Debit) of Data Sheet with a condition of that it corresponds to the Column C
(Particulars) of result sheet & it does not contains 'pp' in the sentences that is displayed in every entry in Column C just before date of Column A.It should contain only numeric data.

Column F (Taxable Import) of result sheet should be extracted from Column H (Debit) of Data Sheet with a condition of that it corresponds to the Column C (Particulars) of result sheet & it does not contains 'Bill No' in the sentences that is displayed in every entry in Column C just before date of Column A.It should contain only numeric data.

Column G (Vat) of result sheet should be extracted from Column H (Debit) of Data Sheet with a condition of that it corresponds to the Column C (Particulars) of result sheet.It(Column H) is the amount that is just right to "as per details" of Column C of Data Sheet .

Column H (Vat in Custom) of result sheet should be extracted from Column H (Debit) of Data Sheet with a condition of that it corresponds to the Column C (Particulars) of result sheet.It(Column H) is the amount that is just right to "as per details" of Column C of Data Sheet .

Column I (Excise Duty) of result sheet should be extracted from Column H (Debit) of Data Sheet with a condition of that it corresponds to the Column C (Particulars) of result sheet.It(Column H) is the amount that is just right to "as per details" of Column C of Data Sheet .It should be noted that 'Excise Duty' name is itself is present in Column C of Data sheet,hence accordingly it should be done.

Column D (Reference No.) of result sheet should be taken from Column C (Particulars).The data should be extracted that contains " Bill No...." or " PP no...". with suffix numeric value to every " Bill No...." or " PP no..."

Hope this would provide sufficient information.This(Result Sheet) is simply,the breakdown in horizontal form datewise of every entry that is shown datewise in Data Sheet.


With Best Rgds,
Suresh