Hi, I need a help. I have two data sheets one containing headers like INVOICE DATE, GSTNUMBER, INVOICENUMBER, INVOICE_DT, INVOICE_VALUE, TAX RATE, TAXABLE_VALUE, DEALER NAME & DEALER_ADDRESS, and another data sheet containing INVOICE DATE, INVOICENUMBER, INVOICE_VALUE, GST VALUE, BASICNONTTAX, CGST_TAXABLE VALUE_5, CGST AMOUNT 5%, SGST_TAXABLE VALUE_5, SGST AMOUNT 5%, CGST_TAXABLE VALUE_12, CGST AMOUNT 12%, SGST_TAXABLE VALUE_12, SGST AMOUNT 12%, CGST_TAXABLE VALUE_18, CGST AMOUNT 18%, SGST_TAXABLE VALUE_18, SGST AMOUNT 18%, CGST_TAXABLE VALUE_28, CGST AMOUNT 28%, SGST_TAXABLE VALUE_28, SGST AMOUNT 28%, DEALER NAME & DEALER_ADDRESS, GST NUMBER. Now I need to create a consolidated file like as the first one with only INVOICE DATE, GSTNUMBER, INVOICENUMBER, INVOICE_DT, INVOICE_VALUE, TAX RATE, TAXABLE_VALUE, DEALER NAME & DEALER_ADDRESS headers. The data is my business data and need the same in the specified format for filing GST return. Please Help.
I have also uploaded two excel files namely All data.xlsx and B2B.xls. Now I want the output data in the format of B2B.xls. Thanks in advance.