GST DATA IN EXCEL-QUERIES

[Razendra]

Dear Sir,

I prepared every month GST data from excel sheet, I am here with attaching Excel file, I want to HSN code details with each HSN code , Taxable value, IGST, CGST, SGST details at a time with total (Example: Hsn code part sales in every day will come, One HSN code details showing at a time using with data menu in filters, but I want to all different HSN code details with Taxable value, IGST....etc. at a time)

 

[AlanSidman]

In attached, I have created a Pivot Table. I hope that from your explanation (which was not exactly clear and you gave no example of what the results should look like) that this is what you are after.