Dear All,
I have an excel database with the following details:
Column A - Names of the City (Delhi, Mumbai, Chennai, etc)
Column B - Month & Year ( 6 months data - Apr 24 to Sep 24)
Column C - Name of the Products (Computer, Printer, Barcode reader, etc)
Column D - No. of Units Sold
Attached is the sample database and the report format.
I am looking for a formula to arrive at the report format as per the attachment.
Thanks in advance.
Subash D
I have an excel database with the following details:
Column A - Names of the City (Delhi, Mumbai, Chennai, etc)
Column B - Month & Year ( 6 months data - Apr 24 to Sep 24)
Column C - Name of the Products (Computer, Printer, Barcode reader, etc)
Column D - No. of Units Sold
Attached is the sample database and the report format.
I am looking for a formula to arrive at the report format as per the attachment.
Thanks in advance.
Subash D